Display timestamp created in MySQL

[torbjoen]

Hi!

I use "NOW()" in my SQL-queries on MySQL to register when records are created or modified.

When I try to display the dates, I have some trouble. In MySQL I use timestamp(14), and if I try to just "echo" the result from the query, I get e.g. "20010622092000".

If I try "$new_date = date ("Y.m.d G:i:s",$old_date);", I get "2038.01.19 4:14:07" which is obviously wrong... I get the same result if I use "getdate()" as well.

Why does the date turn out wrong when I use "date()" or "getdate()" ?

Thanks!!

Torbjørn

[[deleted]]

because date() requires a unix-timestamp, not a mysql interpretation of a timestamp.

Use MySQL's date formatting functions instead, RTM.

[tdrpic]

function db_dateformat($lclDate, $lclFormat) {
// Format a MySQL date field ($lclDate) using $lclFormat
return date($lclFormat, mktime(substr($lclDate, 8, 2), substr($lclDate, 10, 2),
substr($lclDate, 12, 2), substr($lclDate, 4, 2), substr($lclDate, 6, 2), substr($lclDate, 0, 4)));
}

[Anon]

Thank you very much Tomi Drpic.