Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How To Extract Hour From A Date Column In A Table?
You cannot EXTRACT(HOUR) from a column defined as DATE.
You can EXTRACT(TIMEZONE_HOUR) from a column defined as TIMESTAMP WITH
TIME ZONE.
You can use TO_CHAR as indicated previously.
Regards,
Daniel Fink
Received on Wed Apr 05 2006 - 17:37:55 CDT