Hello.

I can't seem to get to_timestamp() or to_date() to work with quarters, 
can anyone see what I'm doing wrong?

e.g.
	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.


Thanks,
Asher.

Responses

• Re: to_timestamp() and quarters at 2010-03-02 14:54:15 from Tom Lane

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)