With ArcMap how to select records created this year 2014

1593
1
12-08-2014 08:28 AM
Highlighted
Occasional Contributor III

Hi all,

How can I select all the records created in year 2014 in ArcMap when the layer is stored in SDE Oracle.

I am using Query Builder in ArcMap.

The field is a date field called DateCreated.

Thanks

I

Reply
0 Kudos
1 Reply
Highlighted
Occasional Contributor III

A way to do that:

[datefield] >= TO_DATE('2014-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS')

Thanks

Reply
0 Kudos