difference in extract and to_char

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
difference in extract and to_char
Дата
Msg-id
3F8B9204.3030904@familyhealth.com.au
Список
I just noticed this fairly silly behaviour:

test=# select to_char(current_date, 'D'), extract(dow from current_date); to_char | date_part
---------+----------- 3       |         2
(1 row)


I guess we can't change that now, but they really should number their 
days from the same base...

Chris



В списке pgsql-hackers по дате отправления
От: Christopher Kings-Lynne
Дата:
Сообщение: comments on casts
От: Tom Lane
Дата:
Сообщение: Re: comments on casts
FAQ