This is hopefully a simple question i am just having a hard time wrapping my head around it,
In a database i have the following value
This value equates to
I can translate that value to the date.time using this query.
"TO_DATE('30/12/1899','DD/MM/YYYY') - (6/24) + ((b.FIELD_NAME/60-360)/60/24)"
What i am looking to do is the reverse, I want to give the query a date such as 2010-02-05 and have it find all values in the db for that date, I assume i would have to use a like statement so i can avoid having to push a time to it.
Any help would be greatly appreciated