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

Home -> Community -> Usenet -> c.d.o.misc -> Re: extracing the hour from a date

Re: extracing the hour from a date

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 25 Mar 2005 10:14:24 -0800
Message-ID: <1111774464.949829.290960@o13g2000cwo.googlegroups.com> 





dang, I've been doing it the long way. So obvious now.



It is strange that TRUNC has documented feature to truncate to hours or
minutes, but cannot return the value with anything other than a time of
12AM.
Received on Fri Mar 25 2005 - 12:14:24 CST












Original text of this message













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