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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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