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