Re: Timestamp docs weirdness
От | Bruce Momjian |
---|---|
Тема | Re: Timestamp docs weirdness |
Дата | |
Msg-id | 200310260442.h9Q4gTB14608@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Timestamp docs weirdness (Marcus Börger <mail@marcus-boerger.de>) |
Ответы |
Re: Timestamp docs weirdness
Re: Timestamp docs weirdness |
Список | pgsql-hackers |
OK, do we want to put back the mention of these in the release notes? The non-zulu ones sound pretty strange to me and might be better left undocumented. --------------------------------------------------------------------------- Marcus B?rger wrote: > Hello Christopher, > > Wednesday, October 22, 2003, 10:21:02 AM, you wrote: > > >>>What in the heck is 'zulu', 'allballs' or 'z'??? > >> > >> > >> 'allballs' probably alludes to the visual appearance of '00:00:00'. 'z' > >> and 'zulu' should be time zones equivalent (or similar?) to UTC or GMT > >> ((US?) military jargon). > > > But they don't work... > > Only the combination of both doesn't work: > template1=# select 'allballs'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select '0:0:0 z'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select '0:0:0 zulu'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select 'allballs'::timetz; > timetz > ------------- > 00:00:00+00 > (1 row) > > template1=# select 'allballs z'::timetz; > ERROR: Bad time external representation 'allballs z' > template1=# select 'allballs zulu'::timetz; > ERROR: Bad time external representation 'allballs zulu' > > Your problem is using 'time' which doesn't know time zones. > > -- > Best regards, > Marcus mailto:mail@marcus-boerger.de > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
В списке pgsql-hackers по дате отправления: