topic Problem with date fields in Oracle in Data Management Questions https://community.esri.com/t5/data-management-questions/problem-with-date-fields-in-oracle/m-p/687073#M38936 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">We<BR />have a strange problem with feature classes in ArcSDE over Oracle that has date<BR />fields.</P><P style="text-align: left;">When<BR />you open the Select By Attribute in ArcMap and you ask for a list of values you<BR />get the values in file geodatabase format (i.e date ' 1/1/2001') and not in Oracle<BR />format (i.e TO_DATE()).</P><P style="text-align: left;">This<BR />happened for all layers in one schema but not for any other schema in the same<BR />database.</P><P style="text-align: left;">As<BR />far as we remember it just started one day.</P><P style="text-align: left;">ArcSDE<BR />10.0 over Oracle11g in Linux.</P><P></P><P style="text-align: left;">Any<BR />idea?</P><P style="text-align: left;">Mody</P></BODY></HTML> Wed, 12 Nov 2014 06:09:51 GMT ModyBuchbinder 2014-11-12T06:09:51Z Problem with date fields in Oracle https://community.esri.com/t5/data-management-questions/problem-with-date-fields-in-oracle/m-p/687073#M38936 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">We<BR />have a strange problem with feature classes in ArcSDE over Oracle that has date<BR />fields.</P><P style="text-align: left;">When<BR />you open the Select By Attribute in ArcMap and you ask for a list of values you<BR />get the values in file geodatabase format (i.e date ' 1/1/2001') and not in Oracle<BR />format (i.e TO_DATE()).</P><P style="text-align: left;">This<BR />happened for all layers in one schema but not for any other schema in the same<BR />database.</P><P style="text-align: left;">As<BR />far as we remember it just started one day.</P><P style="text-align: left;">ArcSDE<BR />10.0 over Oracle11g in Linux.</P><P></P><P style="text-align: left;">Any<BR />idea?</P><P style="text-align: left;">Mody</P></BODY></HTML> Wed, 12 Nov 2014 06:09:51 GMT https://community.esri.com/t5/data-management-questions/problem-with-date-fields-in-oracle/m-p/687073#M38936 ModyBuchbinder 2014-11-12T06:09:51Z