AnsweredAssumed Answered

Problem with date fields in Oracle

Question asked by modybsystematics-co-il-esridist Employee on Nov 11, 2014

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

Outcomes