Skip site navigation (1) Skip section navigation (2)

Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

From: "Ron Mayer" <ron(at)intervideo(dot)com>
To: <andrew(at)dunslane(dot)net>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Date: 2003-09-08 19:16:50
Message-ID: POEDIPIPKGJJLDNIEMBEEEAGDJAA.ron@intervideo.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackerspgsql-patches
andrew(at)dunslane(dot)net wrote:
> 
> Is there a way of producing as well as reading this format? Or did I miss
> something?

Not yet, but I'd be happy to add it.  

My immediate problem was having some 'P1Y6M' intervals to load. 
I posted this much largely because it was useful to me so might 
help others, and to see if it was of interest to others and 
get feedback on what else to change.

I'd be happy to make it produce the output, and have some style
questions for doing so.

I'd hate to trigger this output on the already-existing 'datestyle' 
of 'ISO', since that would break backward compatability.
I do notice that 8601 has both "basic" and "extended" formats.
The "basic format" is more terse ('19980115' instead of '1998-01-15').

Would it be useful if I added a 'datestyle' of 'ISO basic' which
would produce the most terse formats ('19980115' for dates, 
and 'P1Y1M' for intervals)?

   Ron

PS: What's the best inexpenive way for me to know if this changed 
at all between the final draft and the published standard? 

> Ron Mayer said:
> >   This patch allows ISO 8601 "time intervals" using the "format
> >   with time-unit designators" to specify postgresql "intervals".
> >...
> >   Much more info can be found from the draft standard
> >   ftp://ftp.qsl.net/pub/g1smd/154N362_.PDF
> >   The final standard's only available for $$$ so I didn't
> >   look at it.


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-09-08 19:59:20
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Previous:From: Jeroen Ruigrok/asmodaiDate: 2003-09-08 19:00:43
Subject: Re: constraint modification on todo list

pgsql-patches by date

Next:From: Tom LaneDate: 2003-09-08 19:59:20
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"
Previous:From: Ron MayerDate: 2003-09-08 18:59:50
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"

pgsql-advocacy by date

Next:From: Marc G. FournierDate: 2003-09-08 19:36:32
Subject: Re: Need a good slogan to use for ...
Previous:From: Ron MayerDate: 2003-09-08 18:59:50
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"

pgsql-general by date

Next:From: scott.marloweDate: 2003-09-08 19:30:30
Subject: Re: decrypted pwd
Previous:From: Ron MayerDate: 2003-09-08 18:59:50
Subject: Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group