Hi Voytek, Voytek Eymont wrote: > I'm looking at some date/time values in an MySQL tables that are > represented like: > 1076022093 1076020027 1081207440 > are these... the *nix seconds things ? > > how can I interactively convert a single value to human readable format ?
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 Hope this helps! -- Mike -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
