Re: setting default date format

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема Re: setting default date format
Дата
Msg-id 1065005217.2920.11.camel@linda.lfix.co.uk
обсуждение исходный текст
Ответ на Re: setting default date format  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Список pgsql-admin
On Wed, 2003-10-01 at 11:34, Gary Stainburn wrote:
> > In postgresql.conf:
> >
> > DATESTYLE = 'Postgres,European'

> When I did this, and then did 'service postgresql restart' the service failed
> to start.

> BTW, I'm running 7.2.3 from the RH RPMS.

The feature is available in 7.3

In 7.2 I seem to remember you can set an environemntal variable
PGDATESTYLE when starting psql, and you may be able to use SET:

  SET DATESTYLE TO 'Postgres,European';

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Yet if any man suffer as a Christian, let him not be
      ashamed; but let him glorify God on this behalf."
                                        I Peter 4:16


В списке pgsql-admin по дате отправления:

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Re: setting default date format
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Upgrade 7.2.1 to 7.3.4 datetime Error