laptop and a wrench

漏洞

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
漏洞 ID 编号 BUG-000173941
已提交January 29, 2025
上次修改时间February 12, 2025
适用范围ArcGIS Online
找到的版本Nov 2024
操作系统Windows OS
操作系统版本11.0 64 bit
状态As Designed

附加信息

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.

解决办法

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

重现步骤

漏洞 ID: BUG-000173941

软件:

  • ArcGIS Online

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项