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)?
Convert Integer Dates to DateTime format
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)