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 по дате отправления: