X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2A1E19FB4F2 for ; Tue, 29 Aug 2006 17:07:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31239-03-6 for ; Tue, 29 Aug 2006 17:00:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id A6FE19FB33A for ; Tue, 29 Aug 2006 15:13:18 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id B1D1030E1A; Tue, 29 Aug 2006 20:13:17 +0200 (MET DST) From: "codeWarrior" X-Newsgroups: pgsql.sql Subject: Re: to get DD-MM-YYYY format of data Date: Tue, 29 Aug 2006 11:15:33 -0700 Organization: iDynaTECH, Inc. Lines: 457 Message-ID: References: Reply-To: "codeWarrior" Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0036_01C6CB5C.71D5BAE0" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.35 tagged_above=0 required=5 tests=AWL, FORGED_HOTMAIL_RCVD2, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200608/232 X-Sequence-Number: 26190 This is a multi-part message in MIME format. ------=_NextPart_000_0036_01C6CB5C.71D5BAE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 17.10.2. Locale and Formatting DateStyle (string)=20 Sets the display format for date and time values, as well as the rules = for interpreting ambiguous date input values. For historical reasons, = this variable contains two independent components: the output format = specification (ISO, Postgres, SQL, or German) and the input/output = specification for year/month/day ordering (DMY, MDY, or YMD). These can = be set separately or together. The keywords Euro and European are = synonyms for DMY; the keywords US, NonEuro, and NonEuropean are synonyms = for MDY. See Section 8.5, "Date/Time Types" for more information. The = default is ISO, MDY.=20 ""Penchalaiah P."" wrote in message = news:A70AE049E81A6A40879D5DC0AC8C38C906F3F4B0@venus.infics.com... Hi ..=20 =20 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. =20 Thanks & Regards Penchal reddy | Software Engineer =20 Infinite Computer Solutions | Exciting Times.Infinite Possibilities... = SEI-CMMI level 5 | ISO 9001:2000 IT SERVICES | BPO = = =20 Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | = Retail & Distribution | Government = =20 Tel +91-80-5193-0000(Ext:503)| Fax +91-80-51930009 | Cell No = +91-9980012376|www.infics.com =20 Information transmitted by this e-mail is proprietary to Infinite = Computer Solutions and/ or its Customers and is intended for use only by = the individual or entity to which it is addressed, and may contain = information that is privileged, confidential or exempt from disclosure = under applicable law. If you are not the intended recipient or it = appears that this mail has been forwarded to you without proper = authority, you are notified that any use or dissemination of this = information in any manner is strictly prohibited. In such cases, please = notify us immediately at info.in@infics.com and delete this mail from = your records. =20 Information transmitted by this e-mail is proprietary to = Infinite Computer Solutions and / or its Customers and is intended for = use only by the individual or the entity to which it is addressed, and = may contain information that is privileged, confidential or exempt from = disclosure under applicable law. If you are not the intended recipient = or it appears that this mail has been forwarded to you without proper = authority, you are notified that any use or dissemination of this = information in any manner is strictly prohibited. In such cases, please = notify us immediately at info.in@infics.com and delete this email from = your records. =20 ------=_NextPart_000_0036_01C6CB5C.71D5BAE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

17.10.2. Locale=20 and Formatting

DateStyle (string)=20

Sets the display format for date and time values, as well as the = rules for=20 interpreting ambiguous date input values. For historical reasons, this = variable contains two independent components: the output format = specification=20 (ISO, Postgres, SQL, or German) = and the=20 input/output specification for year/month/day ordering (DMY, MDY, or YMD). These can be set separately or together. = The=20 keywords Euro and European are synonyms for DMY;=20 the keywords US, NonEuro, and NonEuropean are=20 synonyms for MDY. See Section 8.5,=20 =93Date/Time Types=94 for more information. The default is ISO, MDY.

 

""Penchalaiah P."" <penchalaiahp@infics.com> = wrote in=20 message n= ews:A70AE049E81A6A40879D5DC0AC8C38C906F3F4B0@venus.infics.com...

Hi ..=20

 

I am using date is data = type to=20 one of the field in my table=85.but when ever I am passing values to = that field=20 it is taking yyy-mm-dd format..

But I don=92t want like = that .. I=20 need like this DD-MM-YYYY.. for this wt I have to=20 do=85

 

Thanks =20 &  Regards

Penchal=20 reddy |=20 Software Engineer=20 =           

Infinite=20 Computer Solutions |=20 Exciting Times=85Infinite Possibilities...

SEI-CMMI=20 level 5 |=20 ISO=20 9001:2000

IT=20 SERVICES |=20 = BPO           &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;            =             &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;            = ;

Telecom=20 |=20 Finance=20 |=20 Healthcare=20 |=20 Manufacturing=20 |=20 Energy=20 & Utilities |=20 Retail=20 & Distribution |=20 Government         &= nbsp;           &n= bsp;           &nb= sp;           &nbs= p;         =20

Tel=20 +91-80-5193-0000(Ext:503)|=20 Fax  +91-80-51930009 |=20 Cell No  +91-9980012376|www.infics.com          

Information=20 transmitted by this e-mail is proprietary to Infinite Computer = Solutions and/=20 or its Customers and is intended for use only by the individual or = entity to=20 which it is addressed, and may contain information that is privileged, = confidential or exempt from disclosure under applicable law. If you = are not=20 the intended recipient or it appears that this mail has been forwarded = to you=20 without proper authority, you are notified that any use or = dissemination of=20 this information in any manner is strictly prohibited. In such cases, = please=20 notify us immediately at=20 info.in@infics.com=20 and=20 delete this mail from your records.

 

Information = transmitted by this=20 e-mail is proprietary to Infinite Computer Solutions and / or = its=20 Customers and is intended for use only by the individual or the = entity=20 to which it is addressed, and may contain information that is=20 privileged, confidential or exempt from disclosure under = applicable law.=20 If you are not the intended recipient or it appears that this = mail has=20 been forwarded to you without proper authority, you are notified = that=20 any use or dissemination of this information in any manner is = strictly=20 prohibited. In such cases, please notify us immediately at=20 info.in@infics.com and delete this email from your=20 = records.
------=_NextPart_000_0036_01C6CB5C.71D5BAE0--