Re: NOTICE: DateStyle is Postgres with Eropean convention - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: NOTICE: DateStyle is Postgres with Eropean convention
Date
Msg-id 3948DC14.A231687F@alumni.caltech.edu
Whole thread Raw
In response to NOTICE: DateStyle is Postgres with Eropean convention  (Marcos Lloret <marcos@second.ival.es>)
List pgsql-general
>     and every time the servlets (via web) are accesing to posgres
> database it shows, in the shell, this:
>             NOTICE:  DateStyle is Postgres with European conventions

Servlets? So are you using JDBC? Some of the interfaces (JDBC is one of
them, afaik) explicitly set the date/time style because they are
responsible for manipulating date/time strings coming back from the
server, and need to ensure that these strings are in a known format.

The notice comes from an explicit "SET DATESTYLE", and should be
considered normal behavior when using some interfaces. Not all
interfaces need to do this automatically, so you will have to be more
specific on your exact scenerio to tell for sure whether you can safely
supress this.

                    - Thomas

pgsql-general by date:

Previous
From: "Cary O'Brien"
Date:
Subject: Re: Crosstab SQL Question
Next
From: Thomas Lockhart
Date:
Subject: Re: Access Permission Denied