File Geodatabase API ExecuteSQL with Datetime condition

KarelVondracek — Mon, 15 Sep 2014 13:04:19 GMT

Hi.

I'm trying to execute and SQL query with datetime condition on a geodatabase, but an Exception ('An invalid SQL statement was used.') is thrown. The code is bellow:

var sqlStatement = "SELECT * FROM TableName WHERE Edited > '15.9.2014 14:28:58'";

foreach (Row row in geodatabase.ExecuteSQL(sqlStatement))

{

var temp = row.GetGlobalID();

Console.Write(temp);

}

Okay, there is someting wrong with SQL statement (the WHERE part), but how can I write it correctly? I there a problem in Datetime format? Or is that kind of query even possible with File Geodatabase API (using version 1.3)?

Re: File Geodatabase API ExecuteSQL with Datetime condition

LanceShipman — Mon, 15 Sep 2014 15:50:29 GMT

Try:

"SELECT * FROM TableName WHERE Edited > date '15.9.2014 14:28:58'"

topic File Geodatabase API ExecuteSQL with Datetime condition in File Geodatabase API Questions

File Geodatabase API ExecuteSQL with Datetime condition

Re: File Geodatabase API ExecuteSQL with Datetime condition