Re: to get DD-MM-YYYY format of data

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: to get DD-MM-YYYY format of data
Date: 2006-08-22 13:27:36
Message-ID: 20060822132736.GA56533@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Aug 22, 2006 at 06:46:11PM +0530, Penchalaiah P. wrote:
> I am using date is data type to one of the field in my table....but when
> ever I am passing values to that field it is taking yyy-mm-dd format..
>
> But I don't want like that .. I need like this DD-MM-YYYY.. for this wt
> I have to do...

See "Date/Time Input," "Date/Time Output," and "Data Type Formatting
Functions" in the documentation:

http://www.postgresql.org/docs/8.1/interactive/datatype-datetime.html
http://www.postgresql.org/docs/8.1/interactive/functions-formatting.html

--
Michael Fuhr

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Brian Cox 2006-08-22 16:40:04 joining VIEWs
Previous Message Alvaro Herrera 2006-08-22 13:27:05 Re: to get DD-MM-YYYY format of data