Re: [sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-22 Thread Brian Smith
Wilson, Ron P wrote: > Heh. He implemented it with a goto statement! It is also interesting that the vast majority of the Zulu people do not live in the "Zulu timezone." - Brian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-22 Thread Wilson, Ron P
rated). Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ralf Junker Sent: Friday, February 22, 2008 9:09 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Unrecognized "Z"

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-22 Thread Ralf Junker
Aristotle Pagaltzis wrote: >* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2008-02-21 13:45]: >> Ralf Junker <[EMAIL PROTECTED]> wrote: >> > SQLite does not recognize "Z" as the zero offset time zone >> > specifier. >> >> If we start accepting any symbolic timezone names, seems like >> we would then n

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-21 Thread Aristotle Pagaltzis
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2008-02-21 13:45]: > Ralf Junker <[EMAIL PROTECTED]> wrote: > > SQLite does not recognize "Z" as the zero offset time zone > > specifier. > > If we start accepting any symbolic timezone names, seems like > we would then need to start accepting them all. N

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-21 Thread Ralf Junker
[EMAIL PROTECTED] wrote: >Ralf Junker <[EMAIL PROTECTED]> wrote: >> SQLite does not recognize "Z" as the zero offset time zone specifier. > >SQLite does not currently accept any timezone specifiers, other >than a hard-coded timezone offset: > > 1981-04-06T14:45:15+01:00 > >If we start accepting

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-21 Thread drh
Ralf Junker <[EMAIL PROTECTED]> wrote: > SQLite does not recognize "Z" as the zero offset time zone specifier. SQLite does not currently accept any timezone specifiers, other than a hard-coded timezone offset: 1981-04-06T14:45:15+01:00 If we start accepting any symbolic timezone names, seems

[sqlite] Unrecognized "Z" UTC time zone signifier

2008-02-21 Thread Ralf Junker
SQLite does not recognize "Z" as the zero offset time zone specifier. "Z" (for 'Zulu time', an alternative name for UTC) is part of the ISO 8601 standard for date and time representations. See http://en.wikipedia.org/wiki/ISO_8601 for details. In this regard, SQLite does not currently follow th