On 27/03/2007 17:00, Tom Lane wrote:
> 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...
Duh! Of course.....I didn't spot that.
Thanks to all who replied.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------