Datetime datatype always ignores time in comparison

Question

Select * from table where Startdatetime<='".$currentdatetime."' AND '".$currentdatetime."'<=t.Enddatetime

$currentdatetime is my variable containing the current date and time in 'Y-m-d H:i:s' format.

My problem is that MySQL is checking the date part properly, but the time is not considered in the check. What am I doing wrong?

check this http://stackoverflow.com/questions/1058031/mysql-compare-two-datetime-fields — Anand Patel, Dec 03 '14 at 11:39
i used 24 hrs clock, i also tried above link method but not working.if a deal startdatetime is (2014-11-12 23:00:00) and enddatetime is (2014-11-13 03:00:00) it should be visible when i enter current time 01:30:00 or else , but it is not happening. just in comparison the time part is not working — user3743834, Dec 03 '14 at 11:50
Are you sure that `Startdatetime` is actually a DATETIME column? — Ja͢ck, Dec 05 '14 at 11:13

Aditya · Answer 1 · 2014-12-05T11:19:40.773

0

Force the variable date time values to match the mysql datetime format and the use it in query

date('Y-m-d H:i:s', strtotime($currentdatetime))

Also make sure database field is of data type datetime.

edited Dec 05 '14 at 11:19

answered Dec 05 '14 at 11:14

Aditya

"$currentdatetime is my variable containing the current date and time in **'Y-m-d H:i:s'** format." – Ja͢ck Dec 05 '14 at 11:15

1 Answers1