Thread

1. Set DATESTYLE='ISO' (Postgres 6.3.2)

   Sangeeta Rao <sangeeta_rao@mw.3com.com> — 1998-08-24T21:41:12Z

   Hi,
   
   I am using Postgresql 6.3.2 and would like to set the datestyle to be ISO.
   
   Here is what I did:
   
   - issued "set datestyle='ISO' " using PQexec() after opening a connection
   with the database. (no errors)
   - Then checked the datestyle from psql
   dbxxx=> show datestyle ;
   response:
   NOTICE: DateStyle is Postgres with US (NonEuropean) conventions.
   - Also, when I open a jdbc connection with debug tracing on I notice that
    the datestyle is Postgres
   
   Why so?? Is this a bug or am I missing something?
   
   Instead of issuing 'set datestyle' command if I set the environment
   variable
   'PGDATESTYLE' to ISO it works fine but I would like to avoid having to do
   this.
   What do I need to do to get the sql command 'set datestyle' to work??
   I appreciate any help.
   
   Thank You,
   SR
   
   
   
   
   
   
   
   
   

2. Re: [GENERAL] Set DATESTYLE='ISO' (Postgres 6.3.2)

   Aleksey Dashevsky <postgres@luckynet.co.il> — 1998-08-26T07:22:47Z

   On Mon, 24 Aug 1998, Sangeeta Rao wrote:
   
   > 
   > Hi,
   > 
   > I am using Postgresql 6.3.2 and would like to set the datestyle to be ISO.
   > 
   > Here is what I did:
   > 
   > - issued "set datestyle='ISO' " using PQexec() after opening a connection
   > with the database. (no errors)
   > - Then checked the datestyle from psql
   > dbxxx=> show datestyle ;
   > response:
   > NOTICE: DateStyle is Postgres with US (NonEuropean) conventions.
   > - Also, when I open a jdbc connection with debug tracing on I notice that
   >  the datestyle is Postgres
   > 
   > Why so?? Is this a bug or am I missing something?
   > 
   > Instead of issuing 'set datestyle' command if I set the environment
   > variable
   > 'PGDATESTYLE' to ISO it works fine but I would like to avoid having to do
   > this.
   
   Setting datestyle variable has effect only for the session it was issued
   in. It was made so to avoid interfernce with another sessions since 
   they could be started not only by you, but someone else (remember --
   PostgreSQL is multiusear). So, the solution is to run postmaster with
   "-e" turned on to get the datestyle you need by default-- for details
   check manpages postmaster(1) and postgres(1).
   
   Aleksey.
   
   
   
   
   

3. Re[2]: [GENERAL] Set DATESTYLE='ISO' (Postgres 6.3.2)

   jose' soares <sferac@bo.nettuno.it> — 1998-08-26T11:27:50Z

   Hello Aleksey,
   
   mercoledì, 26 agosto 98, you wrote:
   
   
   AD> On Mon, 24 Aug 1998, Sangeeta Rao wrote:
   
   >> 
   >> Hi,
   >> 
   >> I am using Postgresql 6.3.2 and would like to set the datestyle to be ISO.
   >> 
   >> Here is what I did:
   >> 
   >> - issued "set datestyle='ISO' " using PQexec() after opening a connection
   >> with the database. (no errors)
   >> - Then checked the datestyle from psql
   >> dbxxx=> show datestyle ;
   >> response:
   >> NOTICE: DateStyle is Postgres with US (NonEuropean) conventions.
   >> - Also, when I open a jdbc connection with debug tracing on I notice that
   >>  the datestyle is Postgres
   >> 
   >> Why so?? Is this a bug or am I missing something?
   >> 
   >> Instead of issuing 'set datestyle' command if I set the environment
   >> variable
   >> 'PGDATESTYLE' to ISO it works fine but I would like to avoid having to do
   >> this.
   
   AD> Setting datestyle variable has effect only for the session it was issued
   AD> in. It was made so to avoid interfernce with another sessions since 
   AD> they could be started not only by you, but someone else (remember --
   AD> PostgreSQL is multiusear). So, the solution is to run postmaster with
   AD> "-e" turned on to get the datestyle you need by default-- for details
   AD> check manpages postmaster(1) and postgres(1).
   AD> Aleksey.
   
   
   The -e option don't allows ISO format, it's a flag to set
   European/NoEuropean.
   
   from man postgres(1):
   
        -e   The -e option controls how dates  are  input  to  and
               output from the database.
   
               If  the  -e option is supplied, then all dates passed
               to and from the frontend processes will be assumed to
               be in European format ie.  DD-MM-YYYY otherwise dates
               are input and output in American format  ie.   MM-DD-
               YYYY
   
   
   To setting date format you can use one of the following:
   
   1. Setting PGDATESTYLE environment variable.
   
    2. Running postmaster using -oe parameter to set format
       date to 'European' convention.
   
    3. Changing the following variables:
            bool EuroDates = false / true
            int  DateStyle = USE_ISO_DATES
            on ~/src/backend/utils/init/globals.c file before PostgreSQL installation.
   
   
   Best regards,
      Jose'                            mailto:sferac@bo.nettuno.it