Default for date field: today vs CURRENT_DATE

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Default for date field: today vs CURRENT_DATE
Дата
Msg-id alpine.LNX.2.20.1901021343520.20959@salmo.appl-ecosys.com
обсуждение исходный текст
Ответы Re: Default for date field: today vs CURRENT_DATE
Список pgsql-general
   Reading the manual I saw that 'today' is a special value, but it did not
work when I used it as a column default; e.g.,
start_date date DEFAULT today,

   Appending parentheses also failed. But, changing today to CURRENT_DATE
worked. I've not found an explanation and would appreciate learning why
'today' fails.

TIA,

Rich


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