Formating Date Data Type?

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Formating Date Data Type?
Date: 2007-03-20 05:08:06
Message-ID: 000001c76b6f$5a677520$170211ac@LIONKING.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Peter Elmers 2007-03-20 09:19:39 LogFile Management
Previous Message Eric 2007-03-19 16:16:46 Re: initdb fails - postgresql does not support leap seconds