topic Re: read ESRI FileGeoDataBase / sql filter on date field in File Geodatabase API Questions

read ESRI FileGeoDataBase / sql filter on date field

RalfWessels — Wed, 17 Jul 2013 11:23:57 GMT

hello,

I have a file geodatabase (10.1) and want to read out data by SQL-select on date fields, but I can`t get it working.

..tried the following codes:
....where date_field < '2013/07/09 17:34:49'
....where date_field < '2013-07-09 17:34:49'
....where "date_field" < date '2013-07-09 17:34:49'

but nothing works.

ralf

Re: read ESRI FileGeoDataBase / sql filter on date field

LanceShipman — Sat, 11 Dec 2021 23:39:44 GMT

This "date_field < date '2013-07-09 17:34:49' " should work.

  EnumRows attrQueryRows;
  if ((hr = table.Search(L"*", L"UP_DATE > date '2007-05-23 11:13:59'", true, attrQueryRows)) != S_OK)
  {
    wcout << "An error occurred while performing the attribute query." << endl;
    ErrorInfo::GetErrorDescription(hr, errorText);
    wcout << errorText << "(" << hr << ")." << endl;
    return -1;
  }

Re: read ESRI FileGeoDataBase / sql filter on date field

RalfWessels — Wed, 17 Jul 2013 17:30:50 GMT

hi Lance,

>>>This "date_field < date '2013-07-09 17:34:49' " should work.

Great, it works - thanx a lot for that quick answer

best greetings from Berlin

Ralf Wessels