Re: Populate a calendar table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rod(at)iol(dot)ie
Cc: "'PostgreSQL'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Populate a calendar table
Date: 2007-03-27 16:00:49
Message-ID: 27754.1175011249@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Raymond O'Donnell" <rod(at)iol(dot)ie> writes:
> to_char(extract (month from d.dates), 'FMmonth') as month_name,
> to_char(extract (day from d.dates), 'FMday') as day_name

I think you want just to_char(d.dates, 'FMmonth') and so on.
What you're invoking above is to_char(numeric) which has entirely
different format codes...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2007-03-27 16:09:07 Re: [GENERAL] Is there a shortage of postgresql skilled ops people
Previous Message Bruce Momjian 2007-03-27 15:56:39 Re: [GENERAL] Is there a shortage of postgresql skilled ops people