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

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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ron Mayer <ron(at)intervideo(dot)com>, <andrew(at)dunslane(dot)net>,<pgsql-patches(at)postgresql(dot)org>
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit
Date: 2003-09-08 21:58:09
Message-ID: Pine.LNX.4.44.0309082357070.1015-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackerspgsql-patches
Tom Lane writes:

> "Ron Mayer" <ron(at)intervideo(dot)com> writes:
> > 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)?
>
> I don't really care for using that name for it --- for one thing, you
> couldn't do
> 	set datestyle to iso basic;
> because of syntax limitations.  A one-word name is a much better idea.

iso8601

Keep in mind that SQL itself is also a kind of ISO, so being more specific
is useful.

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-09-08 22:06:11
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous:From: Jeroen Ruigrok/asmodaiDate: 2003-09-08 21:55:11
Subject: Re: FreeBSD/i386 thread test

pgsql-patches by date

Next:From: Tom LaneDate: 2003-09-08 22:06:11
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous:From: Greg StarkDate: 2003-09-08 21:47:37
Subject: Re: [PATCHES] mcxt.c

pgsql-advocacy by date

Next:From: Tom LaneDate: 2003-09-08 22:06:11
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous:From: Ron JohnsonDate: 2003-09-08 21:40:16
Subject: Re: About GPL and proprietary software

pgsql-general by date

Next:From: Tom LaneDate: 2003-09-08 22:01:02
Subject: Re: why does count take so long?
Previous:From: Greg StarkDate: 2003-09-08 21:55:43
Subject: Re: Can I use PostgreSQL to develop a self-organizing

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