From: | Marcus Brger <mail(at)marcus-boerger(dot)de> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Timestamp docs weirdness |
Date: | 2003-10-22 08:41:27 |
Message-ID: | 157823625906.20031022104127@marcus-boerger.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
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(at)marcus-boerger(dot)de
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-10-22 09:07:32 | Re: [HACKERS] Timestamp docs weirdness |
Previous Message | Christopher Kings-Lynne | 2003-10-22 08:21:02 | Re: Timestamp docs weirdness |
From | Date | Subject | |
---|---|---|---|
Next Message | Serguei Mokhov | 2003-10-22 08:48:23 | Russian NLS update: errors_ru.properties |
Previous Message | Christopher Kings-Lynne | 2003-10-22 08:21:02 | Re: Timestamp docs weirdness |