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 -> Select a Date and time when you only have a date?

Select a Date and time when you only have a date?

From: Bob Maggio <rmaggio_at_courts.state.ny.usNOSPAM>
Date: Thu, 02 Aug 2001 13:24:54 GMT
Message-ID: <3B695517.483FC56A@courts.state.ny.usNOSPAM>

Is there a way to select a date and time from one table, when you only have a date?
I need to be able to select Aug 7, 2001 9:30 am when I only get Aug 7, 2001 from the source table.
I can't trunc the selection becuase I only want to pull records on the give date, at 9:30an, so records at 8:30am need to be left out. So is there a way to get Aug 7, 2001 from one table, (it completely formats to 00:00:00:00 in the time part) and make it Aug 7, 2001 9:30 before I use ot to select from another table? Bob Maggio
NYS Unified Court System
rmaggio_at_courts.state.ny.us Received on Thu Aug 02 2001 - 08:24:54 CDT

Original text of this message

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