Re: Formating Date Data Type? - Mailing list pgsql-novice

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.