I am using mysql to query the database.  It appears that wpdatatables is not correctly selecting the datetime of the records. I am using placeholders for the datetime variables.

I have a query that selects records >= '2017-09-14 16:30:00' 

Two records in the database are '2017-09-14 16:30:00'  

and '2017-09-14 09:00:00' The database column is defined as datetime. The wpdatatables column type is datetime.

The wpdatatables selects both records and should only be selecting one record.

When querying the database directly the query works as expected and only selects one record.

wpdatatables converts the 24 hour time to AM and PM.  the records displayed in the wpdatatables show as 2017-09-14 09:00 AM and 2017-09-14 04:30 PM, since 09 is higher than 04 this record is also selected ??

Changing the Time format did not change the results.  I changed the default placeholder and received the correct result.  As soon as the variable is passed to the placeholder I continue to get both records.

Milan,

Thanks for looking at this.  

My problem is the way the variables are passed to the shortcode.  As soon as the blank is reached no time is specified in the placeholder and therefore all records with that date are shown because I was not using quotes when passing the variable.

I've now updated my code to reflect the passing of the variable within quotes.