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:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org