I am trying write a MySQL query to compare a static datetime value vs. the datetime values stored in my database. I am having trouble doing so.
The datetime values ("JobStartDate") in my database have the following format: '1899-12-30 xx:xx:xx'
The example query below should demonstrate what I am trying to do:
$query = "SELECT * FROM table WHERE JobStartDate < '1899-12-30 09:59:00'";
Can someone please assist me in correcting my syntax so that the two datetime values are evaluated correctly?