MySQL: Fetch nearest date

Hey,

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())

Code (markup):

Even a search in Google didnt help


Please help.

Thanx

 

You could try:

SELECT YourDateField FROM yourTable ORDER BY yourDateField DESC LIMIT 1

 

Try this

select YourDateField from yourTable 
ORDER BY yourDateField DESC LIMIT 1

Code (markup):

 

close call

 

Tried that as well, no luck

 

What is that?

 

try:

select `YourDateField` from yourTable ORDER BY `yourDateField` DESC LIMIT 1

PHP: