Postgres Pro
Downloads
Home   >   mailing lists

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

From Ashish Karalkar
Subject Re: Formating Date Data Type?
Date
Msg-id 000001c76b97$134d5f60$170211ac@LIONKING.COM
Whole thread Raw
In response to Formating Date Data Type?  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
Responses Re: Formating Date Data Type?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
Tree view
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.
 

pgsql-novice by date:

Previous
From: Cesar Alvarez
Date:
Subject: Re: Formating Date Data Type?
Next
From: Michael Fuhr
Date:
Subject: Re: Formating Date Data Type?