Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Select a Date and time when you only have a date?
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