Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
Shopmotion


Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
Affiliates
free forum
 
September 2018
MonTueWedThuFriSatSun
     12
3456789
10111213141516
17181920212223
24252627282930

Calendar Calendar


Filebased Geodatabase Date Filtering

Go down

Filebased Geodatabase Date Filtering

Post  prabhat on Sat Mar 15, 2008 3:49 am

So I had to add some functionality to filter by date and normally this is really simple in ArcObjects as you use the IQueryFilter::WhereClause and enter a date formatted where clause in there.

One problem though. I am using Filebased Geodatabase and I did not know what the correct way to encode the date is! I thought about it for a little while and then decided to use the trusty Query Builder from within ArcMap. It worked a charm.

It is hard to see but they encode the date by pre-pending ‘date ‘ and encoding the actual date in ‘yyyy-mm-dd’ format.

Must archive this somewhere in my brain where it will not get
avatar
prabhat
GIS Geek

Posts : 19
Join date : 2008-03-15
Age : 35
Location : Kanpur India

View user profile

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum