Non-standard TIMESTAMP WITH TIME ZONE literal handling
От | Troels Arvin |
---|---|
Тема | Non-standard TIMESTAMP WITH TIME ZONE literal handling |
Дата | |
Msg-id | pan.2003.08.07.11.04.37.288286@arvin.dk обсуждение исходный текст |
Ответы |
Re: Non-standard TIMESTAMP WITH TIME ZONE literal handling
Re: Non-standard TIMESTAMP WITH TIME ZONE literal handling |
Список | pgsql-bugs |
Hello, In Jim Melton and Alan Simon's "SQL:1999 - Understanding Relational Language Components" (ISBN 1-55860-456-1), they write that the following is to be interpreted as a TIMESTAMP WITH TIME ZONE value: TIMESTAMP '2003-07-29 13:19:30.5+02:00' PostgreSQL interprets the above as a TIMESTAMP WITHOUT TIME ZONE value of '2003-07-29 13:19:30.5', i.e. it simply discards the '+02:00' part and fails to interpret it as being of TIMESTAMP WITH TIME ZONE type. Unless Melton+Simon are wrong, PostgreSQL is not completely following SQL:1999 regarding TIMESTAMP-like literal parsing. Furthermore, as Oracle behaves as Melton+Simon describes, subtle, but potentially nasty portability problems can be imagined, hurting people porting to/from Oracle. -- Greetings from Troels Arvin, Copenhagen, Denmark
В списке pgsql-bugs по дате отправления: