Re: Formating Date Data Type?

From: Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
To: Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Formating Date Data Type?
Date: 2007-03-21 04:29:17
Message-ID: 1174451357.5345.76.camel@it-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Cesar Alvarez 2007-03-21 06:08:00 Re: Formating Date Data Type?
Previous Message Tom Lane 2007-03-20 18:22:03 Re: Very long times to build hash indexes