Re: Formating Date Data Type?

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.

In response to

Responses

Browse pgsql-novice by date

  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?