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: [EMAIL PROTECTED]
-------------------------------------------------------------------------
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
