Re: European date format option
От | Peter Eisentraut |
---|---|
Тема | Re: European date format option |
Дата | |
Msg-id | Pine.LNX.4.30.0109032147500.4304-100000@peter.localdomain обсуждение исходный текст |
Ответ на | European date format option (Nigel Gilbert <N.Gilbert@soc.surrey.ac.uk>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: