Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
Shopmotion


Filebased Geodatabase Date Filtering Empty
Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search
Affiliates
free forum
 
April 2019
MonTueWedThuFriSatSun
1234567
891011121314
15161718192021
22232425262728
2930     

Calendar Calendar


Filebased Geodatabase Date Filtering

Go down

Filebased Geodatabase Date Filtering Empty 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.
Filebased Geodatabase Date Filtering Image-thumb
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
prabhat
prabhat
GIS Geek

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

View user profile

Back to top Go down

Back to top

- Similar topics

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