Hi all -
Implementing my first web service with rails and trying things out using
the “/controller/invoke” interface. Mostly works fine.
But I have a function that takes a datetime and returns all rows that
newer than that. According to the log the SQL it’s generating is this:
SELECT * FROM xxxx WHERE (created_at >= ‘2006-04-25T13:18:31Z’)
I have never seen the “Z” appended like that before. I’m running mysql
4.1.18-standard and when I issue that command I get no results. If I
the ‘Z’ I get what I expect. Also, with the Z I get a warning:
| Warning | 1292 | Truncated incorrect datetime value: ‘2006-04-25T13:23:31Z’ |
This is happening on rails 1.1.2.