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

Re: to_timestamp() and quarters

From: Scott Bailey <artacus(at)comcast(dot)net>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_timestamp() and quarters
Date: 2010-03-02 17:10:40
Message-ID: 4B8D4690.202@comcast.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Tom Lane wrote:
> 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?

+1 for throwing error.
Oracle 10g throws ORA-01820: format code cannot appear in date input format.

Scott

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2010-03-02 18:14:00
Subject: Re: [GENERAL] trouble with to_char('L')
Previous:From: Andrew DunstanDate: 2010-03-02 17:07:04
Subject: Re: USE_LIBXSLT in MSVC builds

pgsql-general by date

Next:From: Lee HachadoorianDate: 2010-03-02 17:21:24
Subject: Array columns vs normalized table
Previous:From: Miguel Angel Hernandez MorenoDate: 2010-03-02 17:08:24
Subject: tipo de dato

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