On Tue, 23 Dec 2008 02:47:07 pm, Jay Pipes <[email protected]> wrote: > > 1) What do people think about changing the prescribed behaviour of > FROM_UNIXTIME() and UNIX_TIMESTAMP() to *not* take into account the > system time zone? Currently, even though we don't support time zones, > for some reason, we're currently accounting for the system time zone in > these functions. I can't really understand why, and it's causing bugs. :)
+1 That does seem a bit weird. Provided UNIX_TIMESTAMP() continues to be in UTC, sure. > 2) What do people think about adding microsecond to the TIMESTAMP data > type by default? This would require 4 more bytes of storage per row. +1000 Please, I beg of you. > 3) What do people think about *removing* the current behaviour of > outputting a microsecond time for DATETIMEs with all 0's? Personally, > I've always found this strange considering MySQL ignores (for storage) > the microsecond time part. We would add a microsecond display to > TIMESTAMP. +1 -- Gary Pendergast Support Engineer (MySQL) Sun Microsystems, www.sun.com _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
