I can't seem to get to_timestamp() or to_date() to work with quarters,
can anyone see what I'm doing wrong?
select to_date('2010-1', 'YYYY-Q');
Gives "2010-01-01" (correct).
select to_date('2010-3', 'YYYY-Q');
Also gives "2010-01-01" (should be 2010-07-01);
Am I misunderstanding how this function works? EXTRACT(QUARTER FROM
date) works fine.
I'm running Postgresql 8.4.2 on a FreeBSD system.
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2010-03-02 11:28:51|
|Subject: Re: How far are projections pushed down the execution tree?|
|Previous:||From: tmp||Date: 2010-03-02 10:31:58|
|Subject: How far are projections pushed down the execution tree?|
pgsql-general by date
|Next:||From: Antonio Goméz Soto||Date: 2010-03-02 11:12:23|
|Subject: How to grant a user read-only access to a database?|
|Previous:||From: Greg Stark||Date: 2010-03-02 09:49:31|
|Subject: Re: Hung postmaster (8.3.9)|