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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-03-02 14:56:42 Re: How to grant a user read-only access to a database?
Previous Message Antonio Goméz Soto 2010-03-02 14:49:19 Re: How to grant a user read-only access to a database?

Browse pgsql-hackers by date

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