Date conversion
09 February 2005, 10:56 AM
#1
Scooby Regular
Thread Starter
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes
on
0 Posts
Date conversion
How do I convert dates (random example: 1105048464) in a MySQL database to DD-MM-YYYY / YYYY-MM-DD etc format?
More to the point, what SQL do I need to query all records with an ent_date earlier than a specified date?
Thanks
More to the point, what SQL do I need to query all records with an ent_date earlier than a specified date?
Thanks
09 February 2005, 12:03 PM
#2
Scooby Regular
The number you have there is the number of seconds since the epoch (which differs across architecture). Check out the UNIXTIME function docs in the MySQL documentation, which will allow you to convert between epoch seconds and MySQL format.
Thread
Thread Starter
Forum
Replies
Last Post