Re: NOTICE: DateStyle is Postgres with Eropean convention

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Marcos Lloret <marcos(at)second(dot)ival(dot)es>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: NOTICE: DateStyle is Postgres with Eropean convention
Date: 2000-06-15 13:37:24
Message-ID: 3948DC14.A231687F@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2000-06-15 13:43:45 Re: Access Permission Denied
Previous Message Andrew Sullivan 2000-06-15 13:37:05 Re: Lock record