What formats should DATETIME DataSet import columns be in?
I am planning on using StreamAPI to import data to a DataSet.
For the column definitions of the DataSet, it appears it should be STRING, DATETIME, DECIMAL, etc...
What is the standard format or approach to importing "date and time" column data? I have not seen any definition of that in the documentation. I assume I should be setting the column to DATETIME.
A value of "18-07-2018 07:49:09" (javascript moment() format of 'DD-MM-YYYY HH:mm:ss') doesn't seem to import anything. And I get no error messages or complaints back from the Stream API.
0
Best Answer
-
It appears that "2018-07-18T13:49:09.000Z" is parseable. For me, generating that in javascript as
moment().toISOString()
0
Categories
- 7.4K All Categories
- 13 Getting Started in the Community
- 150 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部