laptop and a wrench

Bug

Conducting a SQL calculation on a hosted table within ArcGIS Online returns the incorrect date and time if performed on a Date field using the CURRENT_DATE() function.

ArcGIS Online
Bug ID Number BUG-000173941
SubmittedJanuary 29, 2025
Last ModifiedFebruary 12, 2025
Applies toArcGIS Online
Version foundNov 2024
Operating SystemWindows OS
Operating System Version11.0 64 bit
StatusAs Designed

Additional Information

The CURRENT_DATE() function in SQL returns the current date and defaults to midnight UTC time. This is then displayed based on the time zone for the ArcGIS Online organization or profile. Refer to https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm for more information.

Workaround

Calculating fields using the CURRENT_TIME() or CURRENT_TIMESTAMP() functions returns the correct results.

Steps to Reproduce

Bug ID: BUG-000173941

Software:

  • ArcGIS Online

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options