Thread: European date format option

Nigel Gilbert writes:

> The online documentation for SET says:
>
> Running postmaster using the option -o -e to set dates to the
          ^^^^^^^^^^

> European convention.
>
> but attempting to do this results in:
>
> $ pg_ctl start -o -e
    ^^^^^^
> postmaster successfully started
> $ /usr/local/pgsql/bin/postmaster: illegal option -- e
> Try '/usr/local/pgsql/bin/postmaster --help' for more information.

> Is this a bug in postmaster or in the documentation?  Is there a
> workaround (I need all the dates for all connections to be in
> DD-MM-YYYY format)?

That's not what you're going to get out of it anyway.  ("European" is a
much too general term.)  It's better not to rely in these settings.
Instead, explicitly format your values using the to_char() function.
(Set up a view or three if needed.)

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter