BUG-000112945 for ArcGIS GIS Server

不具合 ID 番号	BUG-000112945
送信されました	April 4, 2018
最終更新日	June 5, 2024
適用対象	ArcGIS GIS Server
見つかったバージョン	10.5.1
オペレーティングシステム	Red Hat Enterprise Linux
オペレーティングシステムのバージョン	7.0 64 Bit
ステータス	Will Not Be Addressed

参考情報

By default, services support the SQL 92 standard when querying dates. This format is supported by all data sources on top of which the feature service can run. Format examples of this are as follows: = DATE 'YYYY-MM-DD' = TIMESTAMP 'YYYY-MM-DD HH:MI:SS' The epoch date format (testdate = '1522676196000') is not standard and is not supported across all data sources – it happens to work with elastic but does not work with other sources. For this reason we recommend using the SQL 92 format above.

対処法

It is also possible to note that if the WHERE clause used a specific date stamp in the form of WHERE: testdate='2018-04-01', the query for the relational hosted feature layer returns the features correctly. Applications that use REST services to query date fields based on Epoch time only cannot use this workaround.