Determine datasource type to help format dates in queries

Discussion created by adjones on Jun 22, 2011
I am using the REST query task to return records using a field that uses a date field type (this is in 9.3.1 by the way).

Looking at the whereclause date formatting it looks like it varies depending on the type of workspace the underlying feature class comes from.

In my web application I need to be able to support feature classes in file gdb, shapefiles and SDE (SQL Server) workspaces.  However, as users are able to load the layers in themselves I need to be able to find out the data source programmatically in order to format my where clauses.

Has anyone had this before?  I am not able to use WebADF but can use the SOAP API as well as the REST API.