pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Michael Fuhr <mike@fuhr.org>
To: Penchalaiah P. <penchalaiahp@infics.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: to get DD-MM-YYYY format of data
Date: Tue, 22 Aug 2006 07:27:36 -0600
Message-ID: <20060822132736.GA56533@winnie.fuhr.org> (raw)
In-Reply-To: <A70AE049E81A6A40879D5DC0AC8C38C906F3F4B0@venus.infics.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906F3F4B0@venus.infics.com>

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

view thread (4+ messages)  latest in thread

Message-ID: <20060822132736.GA56533@winnie.fuhr.org>
Permalink:  ../20060822132736.GA56533@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20060822132736.GA56533@winnie.fuhr.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mike@fuhr.org, penchalaiahp@infics.com
  Subject: Re: to get DD-MM-YYYY format of data
  In-Reply-To: <20060822132736.GA56533@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox