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

Re: date/time formats in 7.2

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: wsheldah(at)lexmark(dot)com
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>, General Postgres List <pgsql-general(at)postgresql(dot)org>
Subject: Re: date/time formats in 7.2
Date: 2001-12-31 20:45:13
Message-ID: 3C30CE59.A4CDFD7D@fourpalms.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
> The one variant I'd like it to accept is 'yyyy-mm-ddThh:nn:ss', as in
> '2001-12-31T13:30:46'. This is the ISO-8601 format that perl's Time::Piece and I
> think at least one other perl date module use as their 'standard ISO' output
> format, and the default format that's closest to what Postgresql 7.1.3 seems to
> accept. For now, I'm taking  a string that looks like the above, replacing the T
> with a space with Perl, and then inserting the value into Postgresql. Not a huge
> deal, of course, but it might make it a little more convenient for some of us.

Already accomodated in 7.2.

                  - Thomas

In response to

pgsql-hackers by date

Next:From: Olivier PRENANTDate: 2001-12-31 22:23:11
Subject: Happy new year
Previous:From: Thomas LockhartDate: 2001-12-31 20:43:23
Subject: Re: Latest datetime changes produce gcc complaints

pgsql-general by date

Next:From: Michael McAlpineDate: 2001-12-31 21:08:43
Subject: Large Tables/clustering/terrible performance of Postgresql
Previous:From: Serguei MokhovDate: 2001-12-31 19:36:05
Subject: [OT] Happy New Year tout le monde!

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