Re: [RDBO] DateTime columns

2007-08-09 Thread John Siracusa
On 8/9/07 6:48 AM, Alex Burzyński wrote: > What I'd like to get is when setting value of a date/* columns get it > stored in database server time_zone - so queries in mysql returns what > human reader would expect. You can do this by setting server_time_zone() on the db object: http://www.mail-ar

[RDBO] DateTime columns

2007-08-09 Thread Alex Burzyński
Hi I've got couple of problems with using date/datetime/timestamp/epoch columns. MySQL database is set to use time_zone = SYSTEM, which is BST $ date Thu Aug 9 09:58:59 BST 2007 $ perl -MDateTime -le 'print DateTime->now(time_zone => "local")->time_zone->name' Europe/London What I'd like