comparing datetime

[romram]

We have in our database two fields with datetime type..
How to compare that a date is between these two dates???? :confused:

[bcarl314]

What database server are you using? MySQL, SQL Server, Oracle? They all have similar but different date functions and handle dates a little different.

[romram]

I am using mysql...

[Ökii]

Presuming your input date format is a string of the order '2004-05-15 12:00:00' then you can just use the < less than and > greater than operators.

... 'WHERE `strt_date` < '.$input_date.' AND `end_date` > '.$input_date