Postgres Pro
Downloads
Home   >   mailing lists

Thread: European dates with Win32 version

European dates with Win32 version

From
"Raymond O'Donnell"
Date:
Hi all,

This is probably a silly question, but.......how do I get European-
style dates with 8.0 for Win32?

I'm running on XP Pro, and I've tried adding -o "-o -e" to the pg_ctl
command line (as one would on Linux) - I had to edit the registry to
insert it at the end of the command line. However, the service falls
over with the following in the event log:

   pg_ctl.exe: invalid option (null)

I also tried putting the same options in the "start parameters" part
of the properties sheet for the PostgreSQL service, but while the
service started without problem it made no difference to the date
output.

Any help will be appreciated.

--Ray O'Donnell

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------

Re: European dates with Win32 version

From
Daniel Schuchardt
Date:
Raymond O'Donnell schrieb:
>
> This is probably a silly question, but.......how do I get European-
> style dates with 8.0 for Win32?
>

do you know


# - Locale and Formatting -

datestyle = 'iso, dmy'

in postgresql.conf?

Re: European dates with Win32 version

From
"Raymond O'Donnell"
Date:
On 30 Aug 2004 at 18:19, Daniel Schuchardt wrote:

> do you know
> # - Locale and Formatting -
> datestyle = 'iso, dmy'
> in postgresql.conf?

Now I do!! - that's fixed it - thanks.

--Ray.

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------

Re: European dates with Win32 version

From
Bruce Momjian
Date:
OK, we just tested this on Win32 and it now works fine.  Seems we must
have fixed it somehow between your report and now.

---------------------------------------------------------------------------

Raymond O'Donnell wrote:
> Hi all,
>
> This is probably a silly question, but.......how do I get European-
> style dates with 8.0 for Win32?
>
> I'm running on XP Pro, and I've tried adding -o "-o -e" to the pg_ctl
> command line (as one would on Linux) - I had to edit the registry to
> insert it at the end of the command line. However, the service falls
> over with the following in the event log:
>
>    pg_ctl.exe: invalid option (null)
>
> I also tried putting the same options in the "start parameters" part
> of the properties sheet for the PostgreSQL service, but while the
> service started without problem it made no difference to the date
> output.
>
> Any help will be appreciated.
>
> --Ray O'Donnell
>
> -------------------------------------------------------------
> Raymond O'Donnell     http://www.galwaycathedral.org/recitals
> rod@iol.ie                          Galway Cathedral Recitals
> -------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: European dates with Win32 version

From
"Raymond O'Donnell"
Date:
On 7 Oct 2004 at 14:48, Bruce Momjian wrote:

> OK, we just tested this on Win32 and it now works fine.  Seems we must
> have fixed it somehow between your report and now.

Good on ye! Someone else also pointed out to me the following in
postgresql.conf -

     datestyle = 'iso, dmy'

- which I hadn't been aware of, and which has fixed my problem.
Thanks for the reply!

--Ray.

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------