search

influxdata / influxdb

Scalable datastore for metrics, events, and real-time analytics
https://influxdata.com
Apache License 2.0
28.58k stars 3.53k forks source link

influxdb 1.77 Unix time to RFC3339( Normal time) in SQL query #20018

Open minitomi opened 3 years ago

minitomi commented 3 years ago

Dear Sir I met a problem when I want to get normal time like picture demonstrate issue2 SQl:

Select Spread("Advancenumber") as rings, "time" as Day FROM "Sensors" Where "Advancenumber">0 Group By time(1d)

Return time format is Unix (ms) like 1604188800000 Would you please give me some tips how to transform Unix time (1604188800000) to normal time like (2009.02.14 00:31:30)

Thanks minitomi

minitomi commented 3 years ago

Would you please give me some tips how to transform Unix time (1604188800000) to normal time like (2009.02.14 00:31:30) with SQL inqure