influxdata / influxdata/influxdb

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

Open
#20,018 1 comment 0 reactions 0 assignees View on GitHub
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
![issue2](https://user-images.githubusercontent.com/74391954/99047219-da3f3c00-25ce-11eb-8121-fac3dd8e203d.png)
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.