Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How To Extract Hour From A Date Column In A Table?

Re: How To Extract Hour From A Date Column In A Table?

From: pkl <rc5_at_monochrom.at>
Date: Thu, 06 Apr 2006 19:50:00 +0200
Message-ID: <9fb84$44355516$54728e3c$6549@news.chello.at> 





pkl wrote:


> Well,

> beginning from 9.0.1 you will also find in the docs some syntax like

> 

> SELECT EXTRACT(HOUR FROM my_date_column) FROM my_table

> 

> see e.g.

> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions050.htm#i1017161 

> 

> 

> Regards Peter




I did however not read the (not so) small print and, worse, I did not
test.


Sorry
Received on Thu Apr 06 2006 - 12:50:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US