On Wed Nov 24, 2004 at 13:29:11 +1100, Voytek wrote: > ><quote who="Michael Knight"> >> Hi Voytek, >> Voytek Eymont wrote: > >> Yes, that's a Unix timestamp (number of seconds from January 1, 1970). >> In MySQL you can easily convert these to a readable date using its >> FROM_UNIXTIME function, which you can read more about here: >> >> http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html#IDX1428 > >thanks, Mike > >is there some command line tool to do it for me (not inside MySQL) ? > >basically, I'm looking at some database dump, and, I need to find out what >was the date on ad hoc basis >
Yeah something like: python -c "import time; print time.ctime(1081207440)" Not sure if that is gmt or localtime though. Benno -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
