要查找arcgis圖層,這個query該如何寫,是件麻煩事。比如說,用日期字段來查找。
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5CM5MjNzETM5UGMmZ2MjljZyYzX3QjN1ETM1EzLchDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
該怎麼寫呢?可以這樣寫:
<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'
code='WZ2' and SURVEYDATE<TIMESTAMP '2019-01-01 00:00:00'