Hi all!
A while ago, the list discussed removing timezones from the server and
met with little resistance from folks.
So, some work went in to removing timezones from the server.
However, for reasons I won't go into here, timezones are still present
in the server and are causing, let us say, a bit of a headache. If we
can fully commit to getting rid of timezones, I think I can dramatically
improve the simplicity of how time and dates are handled in the server.
Questions for everyone:
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. :)
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.
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.
Thoughts?
-jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
