From: | "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com> |
---|---|
To: | "Cesar Alvarez" <c(dot)alvarezx66(at)gmail(dot)com> |
Cc: | <pgsql-novice(at)postgresql(dot)org>, "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au> |
Subject: | Re: Formating Date Data Type? |
Date: | 2007-03-21 07:05:35 |
Message-ID: | 000001c76b97$134d5f60$170211ac@LIONKING.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 -----
From: Cesar Alvarez
To: Ashish Karalkar
Cc: pgsql-novice(at)postgresql(dot)org
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Leticia | 2007-03-21 14:29:54 | CHAR data type |
Previous Message | Cesar Alvarez | 2007-03-21 06:08:00 | Re: Formating Date Data Type? |