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