SQL datetime where selection
Posted on 2011-03-24
We have an Oracle backend database that I am trying to select records from where the field EntryDate >= 08/26/2010
EntryDate is in the DateTime format, so not a string, and I have been unsuccesful and forming a query to accomplish this.
If I output the data to the screen for a praticular record I get
even trying a selection of
Select First_Name FROM students WHERE EntryDate ='08/26/2010'
Select First_Name FROM students WHERE EntryDate ='2010-08-26 00:00:00'
I get no results. Can anyone help me form a query to get this accomplished.