CODEWITHSUNDEEP
timestamptimezonetdengine
GeorgeWill93
GeorgeWill93

Reputation: 167

TDengine supported timezone format

To insert a timestamp into TDengine I tried the following formats which are legitimately defined in RFC3339 and ISO8601 standard:

"2018-1-8 9:1:1.952";
"2018-1-8T1:1:1.952-08:00";
"2018-1-8 1:1:1.952-08:00";
"2018-1-81:1:1.952-08:00";

I was expecting insertion of the above timezone formats would have the same result but for some of them the timezone shifting looks incorrect. Anyone know what timezone formats does TDengine support?

Upvotes: 0

Views: 131

Answers (1)

naissance
naissance

Reputation: 36

TDengine currently support:

  1. RFC 3339 standard expression
  2. Using 'yyyy-MM-dd hh:mm:ss' format when using taoSQL to insert

Upvotes: 0

Related Questions