Tags/topics: 
1
Answers
Vote up!
0
Vote down!

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

Asked by: drupal_kid
on August 28, 2012

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

- drupal_kid on August 28, 2012

1 Answer