On Sat, Feb 4, 2012 at 3:39 PM, Olaf van der Spek <[email protected]> wrote: > On Sat, Feb 4, 2012 at 2:18 PM, Harsh vardhan verma > <[email protected]> wrote: >> hiii,, I actually wanted to confirm the working of function "NOW()",, >> the documentation says that, it returns the local time but for me its >> returning GMT,, do I explicitly need to set any timezone in drizzle >> (bcoz my system time is fine) or does the behavior is normal.. > > Does it? > AFAIK docs say current timezone. Current timezone in Drizzle is always GMT.
http://docs.drizzle.org/functions/current_time_functions.html "NOW returns the current date and time. The return value will be expressed as ‘YYYY-MM-DD HH:MM:SS:mmmmmm’ or YYYYMMDDHHMMSS.uuuuuu, depending on whether the function is used in a string or numeric context. The value is expressed in the current time zone." In Drizzle everything is forced into UTC timezone (ie GMT time), this is by design. (Compare with the fact that in Drizzle everything is always UTC-8.) In my opinion the above sentence is misleading. Since there is only one possible time zone, the docs should say "in UTC time zone". If you want to submit a bug, or a fix, or both, that would be a nice low-hanging-fruit task! henrik -- [email protected] +358-40-8211286 skype: henrik.ingo irc: hingo www.openlife.cc My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
