Select to view content in your preferred language

With ArcMap how to select records created this year 2014

1788
1
12-08-2014 08:28 AM
JoseSanchez
Frequent Contributor

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

0 Kudos
1 Reply
JoseSanchez
Frequent Contributor

A way to do that:

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

Thanks

0 Kudos