Ok, this page may explain what's going on... http://msdn.microsoft.com/en-us/library/ms180878(v=sql.100).aspx
For ANSI SQL date format, it IS DATEFORMAT dependent (we're using a datetime not datetime2) and for 8601 it is NOT DATEFORMAT dependant. MSSQL only recognizes the "T" containing one as ISO8601. So, you can change the column type to datetime2, or change DAL to add the "T" back in there. On Wednesday, March 13, 2013 1:28:30 PM UTC-7, Marian wrote: > > ISO 8601 format seems to be a better format, at least for mssql. Patching > this maybe can lead to compatibility issues. I don't know. :( > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
