Colin I guess we should add such feature. Currently we only support timezone specification by INTERVAL. ie SET TIME ZONE INTERVAL '-7:00' Niels On Tue, Aug 07, 2007 at 09:31:38PM +0200, Martin Kersten wrote:
Colin Foss wrote:
Where can I find a list of the MonetDB valid time zone names? This should have been added to the user documentation. (snippet of the prelude operation in the mtime module)
@:TIMEZONES("Wake Island", 12 * 60)@ @:TIMEZONES("Melbourne/Australia", 11 * 60)@ @:TIMEZONES("Brisbane/Australia", 10 * 60)@ @:TIMEZONES("Japan", 9 * 60)@ @:TIMEZONES("Singapore", 8 * 60)@ @:TIMEZONES("Thailand", 7 * 60)@ @:TIMEZONES("Pakistan", 5 * 60)@ @:TIMEZONES("United Arab Emirates", 4 * 60)@ @:TIMEZONES("GMT", 0 * 0)@ @:TIMEZONES("Azore Islands", -1 * 60)@ @:TIMEZONES("Hawaii/USA", -10 * 60)@ @:TIMEZONES("American Samoa", -11 * 60)@ MTIMErule_fromstr(&RULE_MAR, &s1); MTIMErule_fromstr(&RULE_OCT, &s2); @:TIMEZONES2("Kazakhstan", 6 * 60, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("Moscow/Russia", 3 * 60, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("East/Europe", 2 * 60, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("West/Europe", 1 * 60, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("UK", 0 * 0, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("Eastern/Brazil", -2 * 60, RULE_OCT, RULE_MAR)@ @:TIMEZONES2("Western/Brazil", -3 * 60, RULE_OCT, RULE_MAR)@ @:TIMEZONES2("Andes/Brazil", -4 * 60, RULE_OCT, RULE_MAR)@ @:TIMEZONES2("East/USA", -5 * 60, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("Central/USA", -6 * 60, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("Mountain/USA", -7 * 60, RULE_MAR, RULE_OCT)@ @:TIMEZONES2("Alaska/USA", -9 * 60, RULE_MAR, RULE_OCT)@
From the examples I've been able to locate MonetDB only support fixed offsets. i.e. '-07:00' for PDT or '-8:00' for PST.
I tried "set time zone 'US/Pacific'" but monet throws an error.
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl