influxdata / influxdata/influxdb
influxdb 1.77 Unix time to RFC3339( Normal time) in SQL query
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
Dear Sir
I met a problem when I want to get normal time like picture demonstrate

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
Contributor guide
Research direction
The report provides a SQL query and an attached screenshot, but names no repository file, test, or entry point. Start by determining whether InfluxDB supports the requested Unix-millisecond to RFC3339 conversion, and consider the issue resolved only when the supported query syntax or limitation is documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Documentation
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100