Convert Integer Dates to DateTime format

[vmp]

I am a newbie at PHP and MYSQL and I'm working on a custom query.

I have noticed that all dates in the TimeTrex DB are setup as integers.

Would you post a sample MySQL query to retrieve the date in a regular date/time format (e.g. DD-MON-YYYY)?

[shaunw]

Code: Select all

mysql> select FROM_UNIXTIME(created_date) as created_date from users limit 1;
+---------------------+
| created_date        |
+---------------------+
| 2007-06-26 17:24:07 |
+---------------------+
1 row in set (0.02 sec)

[vmp]

Thank you very much