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 -> How to order by hours and minutes of a date column?

How to order by hours and minutes of a date column?

From: Y2K <y2000_at_pacbell.net>
Date: 20 Jun 1999 12:55:00 PDT
Message-ID: <376d4753.167026751@news.concentric.net> 





I need to do a select and order the results by hours and minutes (from
1-24 and 0-59) of a date column.  I tried TRUNC function but it
doesn't seem to work.  This should be an easy question, but I can't
find it from Oracle's documentation.



Can someone help?  Thanks!
Received on Sun Jun 20 1999 - 14:55:00 CDT












Original text of this message













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