November 23rd, 2012, 05:09 AM
I have an sql statement that reads...
SELECT * FROM EventCalendar WHERE department=3 and startdate > '23/11/2012 9:00:00 a.m.'
eventcalander is created as....
see image at lucenz.co.nz/data2.jpg
With the following data in it...
see image at lucenz.co.nz/data1.jpg
now the problem, I get no results. If I change the > for a < then i get results but of course not the ones I am actually after. I must have something wrong but what is it?
November 23rd, 2012, 05:59 AM
are you sure you got your datetime syntax right? Maybe there's a special localization feature I'm not aware of, but as far as I know the literal is
(with some variations)