> 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');
so the underlying implementation does know about timezones. It may only
need a parser adjustment. Will look at it...
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 1998-03-30 16:36:02|
|Subject: Re: Added Having Clause|
|Previous:||From: Bruce Momjian||Date: 1998-03-30 15:25:03|
|Subject: Re: [HACKERS] Reference Manual]|