Is the column a string data type or a date data type?
Assuming it's a date type, look at the to_char() function in the documentation.
Cheers,
~p
On Tue, 2007-03-20 at 10:38 +0530, Ashish Karalkar wrote:
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.