1
Answers
date format in mysql
Hi all,
I'm reading commerce_order using sql - and find that the 'created'
date is simply stored as an int(11) - like this: 1346058279.
Obviously there is a way to 'normalize' this - but how?
Like - when I'd like to extract data in a raw format to XLS.... or a CSV file.... using SQL
Any ideas / suggestions on how to convert back to a 'm/d/y hh:mm:ss' format?
Regards,
Knut
Comments
.... ask google the RIGHT question - and the answer shall be provided.....
for others out there wanting to extract a 'readable' date format from an internal Drupal date - use this sql:
select FROM_UNIXTIME(created) from table....
Cheers,
Knut