Request a Demo
Home   >   mailing lists

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

From Phillip Smith
Subject Re: Formating Date Data Type?
Date
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

pgsql-novice by date:

Previous
From: "Ashish Karalkar"
Date:
Subject: Formating Date Data Type?
Next
From: Cesar Alvarez
Date:
Subject: Re: Formating Date Data Type?