influxDB-时间转换

时间：2020-12-12 18:21:11 收藏：0 阅读：340

> select * from weather
name: weather
time                altitude area humidity temperature
----                -------- ---- -------- -----------
1607747551118397600 1000     北    -4       11
1607747778068174200 500      北    5        18
1607747832128537100 1000     南    -5       12
1607747862517038300 500      南    7        25
> precision rfc3339
> select * from weather
name: weather
time                         altitude area humidity temperature
----                         -------- ---- -------- -----------
2020-12-12T04:32:31.1183976Z 1000     北    -4       11
2020-12-12T04:36:18.0681742Z 500      北    5        18
2020-12-12T04:37:12.1285371Z 1000     南    -5       12
2020-12-12T04:37:42.5170383Z 500      南    7        25

原文：https://www.cnblogs.com/Bluebells/p/14124314.html