Home > mailing lists

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

From	Phillip Smith
Subject	Re: Formating Date Data Type?
Date	March 21, 2007 04:29:35
Msg-id	1174451357.5345.76.camel@it-laptop Whole thread Raw
In response to	Formating Date Data Type? ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
List	pgsql-novice

Tree view

Is the column a string data type or a date data type?

Assuming it's a date type, look at the to_char() function in the documentation.

Cheers,
~p

On Tue, 2007-03-20 at 10:38 +0530, 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.

Attachment

smime.p7s

pgsql-novice by date:

From: "Ashish Karalkar"
Date: 21 March 2007, 04:17:32
Subject: Formating Date Data Type?

From: Cesar Alvarez
Date: 21 March 2007, 06:08:10
Subject: Re: Formating Date Data Type?

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

Attachment

Previous

Next