ISSUE SOLVED / QUESTION ANSWERED – see reply post below.
————–
Hello DG team —
I have a .csv import, one of whose fields contains a raw UNIX date/timestamp, i.e. the time in milliseconds since 1/1/1970 UNIX epoch.
An example of just this column taken from the .csv file:
1709931621652
1709931622650
1709931623141
I like having timestamp data in this format as it is absolute and unambiguous.
How can I import the raw UNIX time into a column in DG, and then have DG format that raw UNIX time for human-readable display?
That is, I want to keep the UNIX time in milliseconds in my data, but have DataGraph reformat it according to the ICU string of my preference.
I am having trouble figuring out if or how there is an ICU format string to handle this. It seems like the ICU-format function in DG is designed to translate any other conceivable format BACK into raw UNIX time (for use within DG internally,) — but not to import raw UNIX time & then display it as one pleases within DG.
-
This topic was modified 7 months, 3 weeks ago by sam.
-
This topic was modified 7 months, 3 weeks ago by sam.