Thread: Timestamp docs weirdness

Timestamp docs weirdness

From
Christopher Kings-Lynne
Date:
What does this in the date/time type docs mean?

zulu, allballs, z    time    00:00:00.00 UTC

Cos it has bizarro behaviour:

In 7.3.4:

australia=# select 'zulu'::time;
ERROR:  Bad time external representation 'zulu'
australia=# select 'allballs'::time;   time
---------- 00:00:00
(1 row)

australia=# select 'z'::time;
ERROR:  Bad time external representation 'z'
australia=# select 'zulu, allballs, z'::time;
ERROR:  Bad time external representation 'zulu, allballs, z'
australia=#

Virtually identical behaviour in 7.4b4.

What in the heck is 'zulu', 'allballs' or 'z'???

Chris






Re: Timestamp docs weirdness

From
Peter Eisentraut
Date:
Christopher Kings-Lynne writes:

> 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).

-- 
Peter Eisentraut   peter_e@gmx.net



Re: Timestamp docs weirdness

From
Christopher Kings-Lynne
Date:
>>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...

Chris




Re: Timestamp docs weirdness

From
Christopher Kings-Lynne
Date:
> '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).

Why do we support just 'zulu' and none of the other magic time zone names:

http://wwp.greenwichmeantime.com/info/timezone.htm

Chris




Re: Timestamp docs weirdness

From
Tom Lane
Date:
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Why do we support just 'zulu' and none of the other magic time zone names:
> http://wwp.greenwichmeantime.com/info/timezone.htm

AFAIK, zulu is the only one of those "military" designations that has
any currency at all.  I don't feel a strong need to import the rest
... particularly not the single-letter versions; the presence of those
would allow the system to accept many typos :-(

The real answer to all such questions, though, is that we ought not have
the set of known timezone names locked down in code at all.  It should
come from a user-alterable configuration file.  This would let us get
rid of "australian_timezones" as well as solve the perennial gripes from
out-of-the-way places that their favorite local zone name isn't
recognized.
        regards, tom lane


Re: Timestamp docs weirdness

From
Marcus Börger
Date:
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



Re: Timestamp docs weirdness

From
Bruce Momjian
Date:
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
 


Re: Timestamp docs weirdness

From
Christopher Kings-Lynne
Date:
> 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.

What's there to go in the release notes?  We haven't changed any code, 
and zulu is the only 'named' timezone we support (from checking source 
code).

I've just reorganised the docs, so that it's actually explained what 
they are.

Chris




Re: Timestamp docs weirdness

From
Bruce Momjian
Date:
Oh, OK, sounds like we are good.

---------------------------------------------------------------------------

Christopher Kings-Lynne wrote:
> > 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.
> 
> What's there to go in the release notes?  We haven't changed any code, 
> and zulu is the only 'named' timezone we support (from checking source 
> code).
> 
> I've just reorganised the docs, so that it's actually explained what 
> they are.
> 
> Chris
> 
> 

--  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
 


Re: Timestamp docs weirdness

From
Tom Lane
Date:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 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.

AFAICS the updated docs are correct.  Since the code behavior has not
changed, there is no need for a release-notes entry, is there?

>> Only the combination of both doesn't work:
>> template1=# select 'allballs zulu'::timetz;
>> ERROR:  Bad time external representation 'allballs zulu'

That's because 'allballs' is defined as '00:00:00 UTC', that is,
it already defines a timezone.  The above is a double specification
of timezone and gets the same error as

regression=# select '00:00:00 UTC UTC'::timetz;
ERROR:  invalid input syntax for type time with time zone: "00:00:00 UTC UTC"

I see no bug here.
        regards, tom lane