Problem with date fields in Oracle

1243
0
11-11-2014 10:09 PM
ModyBuchbinder
Esri Regular Contributor

We
have a strange problem with feature classes in ArcSDE over Oracle that has date
fields.

When
you open the Select By Attribute in ArcMap and you ask for a list of values you
get the values in file geodatabase format (i.e date ' 1/1/2001') and not in Oracle
format (i.e TO_DATE()).

This
happened for all layers in one schema but not for any other schema in the same
database.

As
far as we remember it just started one day.

ArcSDE
10.0 over Oracle11g in Linux.

Any
idea?

Mody

0 Kudos
0 Replies