This one time, at band camp, 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 ?
They sure look like it! As far as I know, MySQL stores dates as integers,
by converting them to unix time, i.e. seconds since epoch (1st Jan 1970,
00:00).
I can only guess the reason for no date or time types in MySQL is that the
infinitely wise and powerful MySQL developers decided that the cost to
performance is too great. Either that or the lack of said types is a
documented feature of the database.
>how can I interactively convert a single value to human readable format ?
Depends how interactive you want to get!
fully immersive: pen+paper
pocket calculator
copy and paste numbers into python interpreter
copy and paste numbers into spreadsheet
use function call in the calling script
not interactive: use function call in sql
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
