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

• to_timestamp() and quarters at 2010-03-02 10:47:03 from Asher Hoskins

Responses

• Re: to_timestamp() and quarters at 2010-03-02 15:15:29 from A. Kretschmer
• Re: to_timestamp() and quarters at 2010-03-02 17:10:40 from Scott Bailey

pgsql-hackers by date

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

pgsql-general by date

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