Postgres Pro
Downloads
Home   >   mailing lists

Re: to get DD-MM-YYYY format of data - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: to get DD-MM-YYYY format of data
Date
Msg-id 20060822132736.GA56533@winnie.fuhr.org
Whole thread Raw
In response to to get DD-MM-YYYY format of data  ("Penchalaiah P." <penchalaiahp@infics.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Penchalaiah P."
Date:
Subject: to get DD-MM-YYYY format of data
Next
From: Alvaro Herrera
Date:
Subject: Re: to get DD-MM-YYYY format of data