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 22:39:44
Message-ID: Pine.LNX.4.44.0309090032220.1015-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-generalpgsql-hackerspgsql-patches
Tom Lane writes:

> Yes, but by the same token "iso8601" isn't specific enough either.
> Several of the other input formats we support have at least as good a
> claim on that name.

The only input formats we support are along the lines of

@ 1 year 2 mons 3 days 4 hours 5 mins 6 secs
@ 1 year 2 mons 3 days 04:05:06

These are also the supported output formats (the first you get for 'sql',
'postgres', and 'german' formats; the second is 'iso').  A quick check of
ISO 8601 shows, however, that neither of these are close to anything
specified in that standard.

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


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-09-08 22:40:23
Subject: Re: constraint modification on todo list
Previous:From: Bruce MomjianDate: 2003-09-08 22:36:07
Subject: Re: FreeBSD/i386 thread test

pgsql-patches by date

Next:From: Tom LaneDate: 2003-09-08 22:45:03
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous:From: Tom LaneDate: 2003-09-08 22:26:01
Subject: Re: [PATCHES] mcxt.c

pgsql-advocacy by date

Next:From: Tom LaneDate: 2003-09-08 22:45:03
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous:From: Tom LaneDate: 2003-09-08 22:06:11
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

pgsql-general by date

Next:From: Tom LaneDate: 2003-09-08 22:45:03
Subject: Re: ISO 8601 'Time Intervals' of the 'format with time-unit deignators'
Previous:From: Karsten HilbertDate: 2003-09-08 22:37:44
Subject: Re: Can I use PostgreSQL to develop a self-organizing

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