I am using the following SQL query to query data between a certain set of dates:
SELECT source, eventtime
FROM alarm_events
WHERE eventtime BETWEEN Mon Jul 06 09:22:08 CDT 2015 and Mon Jul 06 09:22:18 CDT 2015
I keep getting an error and I know that it is in the third line. Is the date format going to present an issue between my SQL DB and my ignition platform? Or maybe a better question is what format should my date be in for this to work?
I would like to be able to tie the begin date and end date to a date selector on the screen that I am using, but am not sure it is possible considering the format differences between the two programs.
Thanks in advance for the help!