I am in INDIA
Tried with to_char but it does not take column name/actuall date value as argument for date
With Regards
Ashish
----- Original Message -----
Sent: Wednesday, March 21, 2007 11:38 AM
Subject: Re: [NOVICE] Formating Date Data Type?
shouldn't windows make that format, with the regional Settings?
where are you developing your APP.
Ashish Karalkar wrote:
Hello list,
I am storing date as '2007-04-15' in data base as YYYY-MM-DD
Now I want to format this to 15-Apr-2007.
Is there any way
I tries to use extract function but it gives in only digit format also this function does not except column name as input
Is there any way??
Thanks In advance.