Interesting. How's the language support for TAI64? One of the nicest things about Epoch time is that any Perl or C (and many other) program anywhere (on UNIX!) knows how to turn that int into a time-zone aware human-readable string.
Cheers. -Dana > -----Original Message----- > From: Michael T. Babcock [SMTP:[EMAIL PROTECTED]] > Sent: Monday, December 23, 2002 10:55 AM > To: Dana Diederich > Cc: 'Keith C. Ivey'; [EMAIL PROTECTED]; Akash > Subject: Re: What, if anything, is wrong with UNIX Epoch time stamps? > [Was: R E: TimeStamp in MySQL reqd NULL] > > Dana Diederich wrote: > > >Can anyone share and/or comment about the use of Epoch time, especially > the > >hazards? I'm asking because I want to make sure that I haven't built a > >comfortable little box that un-necessarily excludes some useful > functions. > > > > > > I use Epoch time myself, except where I use TIMESTAMP to record > last-updated values automatically (and select it with > UNIX_TIMESTAMP(...)" every time. > > I personally prefer TAI64 time (sub-second precision; see > http://cr.yp.to/libtai/tai64.html). For a comparison of how this > differs from UNIX time, see http://cr.yp.to/proto/utctai.html at the > same site. I'm surprised SQL hasn't been updated to support new time > formats yet, but oh well. > > -- > Michael T. Babcock > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock > ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Stores, Inc. Confidential ********************************************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
