<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 -- Voytek -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
