Re: [GENERAL] Default date format to ISO + 1 bug

Поиск
Список
Период
Сортировка
От Patrick Welche
Тема Re: [GENERAL] Default date format to ISO + 1 bug
Дата
Msg-id 20000113155805.J12705@quartz.newn.cam.ac.uk
обсуждение исходный текст
Ответ на Default date format to ISO + 1 bug  (Web Manager <web@inter-resa.com>)
Список pgsql-general
On Thu, Jan 13, 2000 at 10:09:35AM -0500, Web Manager wrote:
> Hello,
>
> since I am a simple Postgres user, I don't understand the instruction to
> change the postgresql default date format from 01-13-2000 to 2000-01-13

Either set the environment variable 'PGDATESTYLE', eg for csh

setenv PGDATESTYLE European

or in your connection to the database

SET DateStyle TO 'European';

> And then... I have a second broblem:
... 'now' broken, now() working
> What is wrong?

I think this one was mentioned a few days ago, so it's a "known problem"?

Cheers,

Patrick

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

Предыдущее
От: Jim Mercer
Дата:
Сообщение: Re: [GENERAL] Default date format to ISO + 1 bug
Следующее
От: admin
Дата:
Сообщение: oid data type