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

Re: to_timestamp() and quarters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Asher Hoskins <asher(at)piceur(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_timestamp() and quarters
Date: 2010-03-02 14:54:15
Message-ID: 15109.1267541655@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Asher Hoskins <asher(at)piceur(dot)co(dot)uk> writes:
> I can't seem to get to_timestamp() or to_date() to work with quarters, 

The source code says

                 * We ignore Q when converting to date because it is not
                 * normative.
                 *
                 * We still parse the source string for an integer, but it
                 * isn't stored anywhere in 'out'.

That might be a reasonable position, but it seems like it'd be better to
throw an error than silently do nothing.  Anybody know what Oracle does
with this?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: A. KretschmerDate: 2010-03-02 15:15:29
Subject: Re: to_timestamp() and quarters
Previous:From: Tom LaneDate: 2010-03-02 14:42:38
Subject: Re: USE_LIBXSLT in MSVC builds

pgsql-general by date

Next:From: Thom BrownDate: 2010-03-02 14:56:42
Subject: Re: How to grant a user read-only access to a database?
Previous:From: Antonio Gom├ęz SotoDate: 2010-03-02 14:49:19
Subject: Re: How to grant a user read-only access to a database?

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