Re: to_char syntax

From: Randy Harris <randy_at_SpamFree.com>
Date: Thu, 23 Feb 2006 04:09:06 GMT
Message-ID: <CzaLf.24128$_S7.21482@newssvr14.news.prodigy.com>

"Liz J" <thejordanschangethistoanatsignclara.net> wrote in message news:1140653404.29042.0_at_damia.uk.clara.net...
> Hi
>
> Could someone help me with some syntax?
>
> I know that
>
> SELECT To_char (sysdate, 'ddth Month YYYY')
>
> will give me the format I want if it is today's date that I need.
>
> But suppose it is another date that I know - say 3rd February 2006?
>
> I can't get the syntax right.
>
> thanks
>
> Liz
>

How about:

To_char ('03-Feb-2006', 'ddth Month YYYY')

-- 
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

Received on Wed Feb 22 2006 - 22:09:06 CST