Skip site navigation (1) Skip section navigation (2)

Re: date formats with ecpg and JDBC

From: "Nicolas Bazin" <nbazin(at)ingenico(dot)com(dot)au>
To: "Thomas Lockhart" <lockhart(at)fourpalms(dot)org>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: date formats with ecpg and JDBC
Date: 2002-05-17 05:46:55
Message-ID: 000d01c1fd66$40ec15f0$660d090a@software.ingenico.com.au (view raw or flat)
Thread:
Lists: pgsql-interfaces
Well I see that the output formats are either:
ISO, SQL, Postgres or German. I don't know what "traditional Postgres
format" is but any of this list seems to be what I want.
Does it mean that Postgres cannot output dates in US format?

----- Original Message -----
From: "Thomas Lockhart" <lockhart(at)fourpalms(dot)org>
To: "Nicolas Bazin" <nbazin(at)ingenico(dot)com(dot)au>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Friday, May 17, 2002 11:23 AM
Subject: Re: [INTERFACES] date formats with ecpg and JDBC


> > I have that application that handles dates in US format. I setup the
> > variable DATESTYLE to US and dates are parsed correctly when I write
> > in the database, but when I read a date then I always get it in ISO
> > format? Is it normal or a bug? Or I need to do something else I dont
> > do?
>
> Look at the other options available for SET DATESTYLE.
>
>                    - Tom
>
>



In response to

Responses

pgsql-interfaces by date

Next:From: Peter EisentrautDate: 2002-05-17 13:37:05
Subject: Re: [INTERFACES] libpgtcl - backend version information patch
Previous:From: Thomas LockhartDate: 2002-05-17 01:23:12
Subject: Re: date formats with ecpg and JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group