How do I get the nearest date/time row populated using sql?
The datatype for this date field is "datetime"
I tried the folowing, but does not work properly
select YourDateField from yourTable where yourDateField <= date(now())
Even a search in Google