European date format option

Started by Nigel Gilbertover 24 years ago2 messagesgeneral
Jump to latest
#1Nigel Gilbert
N.Gilbert@soc.surrey.ac.uk

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.

using:

template1=# select version();
version
-----------------------------------------------------------------
PostgreSQL 7.1.2 on sparc-sun-solaris2.7, compiled by GCC 2.8.1
(1 row)

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)?

Nigel Gilbert

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Nigel Gilbert (#1)
Re: 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