> 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