date formatting

[Anon]

Does anyone know how to format a date created using a MySQL timestamp? I get a date like this when retrieving it from the database: 20010307

I tried some of the PHP date functions, but they didn't work.

Thanks

[enterume]

You can try this:

$new_date = date("Y-m-d H:i:s", MySQL_timestamp);

[ziong]

it maybe wrong,
since the parameter "timestamp" of date is a UNIX timestamp, the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT). But Mysql timestamp is in format like YYYYMMDDHHIISS, which is difference form UNIX timestamp.

so should do this:
$year = substr($mysql_timestamp, 0, 4);
$month = substr($mysql_timestamp, 4, 2);
$day = substr($mysql_timestamp, 6, 2);
$hour = substr($mysql_timestamp, 8, 2);
$min = substr($mysql_timestamp, 10, 2);
$sec = substr($mysql_timestamp, 12, 14);

$new_date = data("Y-m-d H:i:s", mktime($hour, $min, $sec, $month, $day, $year ));

correct me if i'm wrong

[Anon]

That sets the date to 1970-08-20

🙂

[Anon]

I tried this...reducing it a little bit since I'm just using Y-m-d so I have this:

$year = substr($date, 0, 4);
$month = substr($date, 4, 2);
$day = substr($date, 6, 2);

$new_date = date("Y-m-d", mktime($month, $day, $year ));

But this just returns the current date. Not the date that the timestamp was created. 🙁

Thanx

[ziong]

u should use like this:
$new_date = date ("M-d-Y", mktime (0,0,0,$month,$day,$year));

[Anon]

Great! Thanks, that worked. 🙂