January 11th, 2004, 08:26 PM
Join Date: Aug 2003
Time spent in forums: < 1 sec
Reputation Power: 11
how do I filter the time field in oracle
I have a table
What I actually required is the mydate (18-Jan-2004), starttime( 05:00 pm), endtime (06:00 pm).
I am storing the data as follow:
mydate 18-Jan-2004 12:00:00 AM
starttime 18-Jan-2004 05:00:00 PM
endtime 18-Jan-2004 06:00:00 PM
Is there a better way to store these information?
Say I current machine time (not the server time) is 04:00 PM and I would like to use this information to find id which starttime is later than 04:00 PM. Should I use to_date or is there a better way to construct the SQL statement?