arcgis图层按日期字段查找 野性酷女 2023-01-06 01:28 234阅读 0赞 要查找arcgis图层,这个query该如何写,是件麻烦事。比如说,用日期字段来查找。 ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xlZnRmaXN0_size_16_color_FFFFFF_t_70_pic_center] 该怎么写呢?可以这样写: <DateField> = DATE 'YYYY-MM-DD' <DateField> = TIMESTAMP 'YYYY-MM-DD HH:MI:SS' 1)以日期为尺度 code='WZ2' and SURVEYDATE>=DATE '2018-01-01' and SURVEYDATE<DATE '2019-01-01' 2)以日期 + 时间为尺度 code='WZ2' and SURVEYDATE<TIMESTAMP '2019-01-01 00:00:00' ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xlZnRmaXN0_size_16_color_FFFFFF_t_70_pic_center 1] [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xlZnRmaXN0_size_16_color_FFFFFF_t_70_pic_center]: /images/20221119/7a386400b5104bfb95b7e23e37c1f04a.png [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xlZnRmaXN0_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/20210113170710451.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xlZnRmaXN0,size_16,color_FFFFFF,t_70#pic_center
还没有评论,来说两句吧...