Re: [DOCS] Reference Manual
От | Thomas G. Lockhart |
---|---|
Тема | Re: [DOCS] Reference Manual |
Дата | |
Msg-id | 351FC58D.BD7C7C97@alumni.caltech.edu обсуждение исходный текст |
Ответ на | Reference Manual ("Jose' Soares Da Silva" <sferac@proxy.bazzanese.com>) |
Ответы |
Re: [HACKERS] Re: [DOCS] Reference Manual
|
Список | pgsql-hackers |
> I'm writing Reference Manual and I have two questions: > > 1 - Why PostgreSQL accept HOUR, MINUTE and SECOND to extract if from a > date ? > EXTRACT (field FROM date_expression) > There are no such fields on a date! And it returns zeros for those fields. I think that is OK; it makes for a symmetric implementation... > - TIMEZONE_HOUR > - TIMEZONE_MINUTE Hmm. Don't do these yet. But: tgl=> select date_part('timezone', 'now'); date_part --------- -7200 (1 row) so the underlying implementation does know about timezones. It may only need a parser adjustment. Will look at it... - Tom
В списке pgsql-hackers по дате отправления: