I am in INDIA
Tried with to_char but it does not take column name/actuall date value as argument for date
----- Original Message -----
From: Cesar Alvarez
To: Ashish Karalkar
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:
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.
In response to
pgsql-novice by date
|Next:||From: Leticia||Date: 2007-03-21 14:29:54|
|Subject: CHAR data type|
|Previous:||From: Cesar Alvarez||Date: 2007-03-21 06:08:00|
|Subject: Re: Formating Date Data Type?|