ArcGIS REST API ( 10.2) fails on querying date

[DeminHu]

I have an application, querying ArcGIS Server layer date field  ( data is in SDE 10.1 with SQL Server Enterprise), it worked perfectly until I updated to ArcGIS 10.2.

The same query runs OK on ArcMap and any  other no GIS tools,  but not ArcGIS Server Silverlight App, ArcGIS Server REST API, always get the error : Unable to complete operation.

In the same App, I also use  WCF to for other date queries ( not related to GIS API), it is fine.

It seems the ESRI ArcGIS REST API ( 10.2) has some issue here, anybody has such problem?

[MarkCederholm]

I'm having problems left and right with 10.2.  "Where" statements that worked fine in 10.1 are failing in 10.2.  Statements such as these:

TRIM(FIELDNAME) = 'VALUE'
OBJECTID IN (SELECT ....)

This is a step backwards and I am not happy about it.  This will definitely hold back rolling it into production.

[RichardWatson]

http://forums.arcgis.com/threads/94497-Date-format-issue-after-upgrading-from-10.1-to-10.2

[MarkCederholm]

I was afraid that 10.2 was blocking database-specific SQL.  Drat.  Now I have to decide whether to change my code or change the Server settings.