topic SQL Reference Date in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/sql-reference-date/m-p/1045846#M7111 <P>Dear Community,</P><P>i`ve got still a Problem with my date format.</P><P>I`ve got netCDF Data from 01.01.2019 and in my attributtable in Pro it is shown up from 1899...</P><P>Now i find this information in the uploaded picture</P><P>and here is the link...</P><P><A href="https://desktop.arcgis.com/en/arcmap/10.3/map/working-with-layers/sql-reference-for-query-expressions-used-in-arcgis.htm" target="_blank">https://desktop.arcgis.com/en/arcmap/10.3/map/working-with-layers/sql-reference-for-query-expressions-used-in-arcgis.htm</A></P><P>So i really don`t know how to handle SQL language and what it means, but I think im on the right way why my date isn`t shown up, right?</P><P>How can I change it to 01-01-2019 instead of the reference time of ArcGIS</P><P>&nbsp;</P><P>Any proposals?</P><P>&nbsp;</P><P>Greetings,</P><P>Andrea</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 12 Apr 2021 08:58:48 GMT A_n_d_r_e_a 2021-04-12T08:58:48Z SQL Reference Date https://community.esri.com/t5/geodatabase-questions/sql-reference-date/m-p/1045846#M7111 <P>Dear Community,</P><P>i`ve got still a Problem with my date format.</P><P>I`ve got netCDF Data from 01.01.2019 and in my attributtable in Pro it is shown up from 1899...</P><P>Now i find this information in the uploaded picture</P><P>and here is the link...</P><P><A href="https://desktop.arcgis.com/en/arcmap/10.3/map/working-with-layers/sql-reference-for-query-expressions-used-in-arcgis.htm" target="_blank">https://desktop.arcgis.com/en/arcmap/10.3/map/working-with-layers/sql-reference-for-query-expressions-used-in-arcgis.htm</A></P><P>So i really don`t know how to handle SQL language and what it means, but I think im on the right way why my date isn`t shown up, right?</P><P>How can I change it to 01-01-2019 instead of the reference time of ArcGIS</P><P>&nbsp;</P><P>Any proposals?</P><P>&nbsp;</P><P>Greetings,</P><P>Andrea</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 12 Apr 2021 08:58:48 GMT https://community.esri.com/t5/geodatabase-questions/sql-reference-date/m-p/1045846#M7111 A_n_d_r_e_a 2021-04-12T08:58:48Z