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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
