Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 27 Mar 2007 12:00:49 -0400
"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
- Follow-Ups:
- Re: Populate a calendar table
- From: Raymond O'Donnell
- Re: Populate a calendar table
- References:
- Populate a calendar table
- From: Raymond O'Donnell
- Populate a calendar table
- Prev by Date: Re: [pgsql-advocacy] Is there a shortage of postgresql skilled ops people
- Next by Date: Re: Populate a calendar table
- Previous by thread: Re: Populate a calendar table
- Next by thread: Re: Populate a calendar table
- Indexes: