Home > mailing lists

Formating Date Data Type? - Mailing list pgsql-novice

From	Ashish Karalkar
Subject	Formating Date Data Type?
Date	March 21, 2007 04:17:32
Msg-id	000001c76b6f$5a677520$170211ac@LIONKING.COM Whole thread Raw
Responses	Re: Formating Date Data Type? (Phillip Smith <phillip.smith@weatherbeeta.com.au>) Re: Formating Date Data Type? (Cesar Alvarez <c.alvarezx66@gmail.com>)
List	pgsql-novice

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: Tom Lane
Date: 20 March 2007, 18:22:15
Subject: Re: Very long times to build hash indexes

From: Phillip Smith
Date: 21 March 2007, 04:29:35
Subject: Re: Formating Date Data Type?