Sort date and time
Posted by:
jlemke
Date: January 30, 2007 07:08PM
I have a simple question about sorting records based on seperate date and time fields.
Take the following example query:
SELECT some_id FROM datatable WHERE date >= '2007-01-01' and time >= '05:00:00'
This returns all of the records with a date greater than 2007-01-01 and then reduces the records to only those with a time greater than 5:00. I want all records after 2007-01-01 5:00.
Thanks
Subject
Written By
Posted
Sort date and time
January 30, 2007 07:08PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.