Please help with DATE/timestamp problem

gordonrp

Hey guys, I am a newb to using dates and time stamps, Im hoping someone could help me out here.

I have a php table which I have a timestamp field in, I use the MYSQL NOW function to put in the current time stamp.

Which looks like: 20040608230338

I need to convert that to a date string. But my code is outputing

Monday January 18 2038

$date is set to = 20040608230338

My code is this:

$date2=date('l F j Y', "$date");
print "$date2";

Any pointers would be very much appreciated, thanks..

LordShryku

With that field type, you'd be better off using mysql's date_format function to format the output.

gordonrp

I need to format it in php though, on the web page and not as a sql query...

LordShryku

Ok.........
Can you at least use the unixtimestamp function so your previous solution would work?

hyabusa

Well MySQL's now() function stores the date in the format:

YYYYMMDDHHMMSS

This probably isn't the best solution but it may give you some ideas:

$date = '20040608230338';

$year = substr($date, 0, 4);
$month = substr($date, 5,6);
$day = substr($date,7,8);
$hour = substr($date,9,10);
$minute = substr($date,11,12);
$seconds = substr($date, 13,14);

Craig

phlow

Note that

substr($myString, $x, $y)

returns the characters from $x to $x+$y, not the characters from $x to $y.