Timestamp to readable date? :: Zikula Community

Timestamp to readable date?

Posted: 17.03.2005, 00:58

rank:

Helper

registered:

November 2004

Status:

offline

last visit:

12.03.07

Posts:

387

I have a MySQL timestamp in my module. Is there a built-in way to display this in PostNuke? I can't seem to get it to look okay.
- notify mod
Posted: 17.03.2005, 20:08

rank:

Softmore

registered:

November 2004

Status:

offline

last visit:

06.03.06

Posts:

66

I do not think PostNuke is meant to give you such a function ...

try this in your SQL:
DATE_FORMAT(date,format)

more details here:
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

Otherwise you will need to decode the MYSQL timestamp yourself with PHP ...

Remember MYSQL timestamp is DIFFERENT from the Unix timestamp

Alexan
- notify mod