Internal Date Format Used in DSS Internal json files
raviagrawal
Partner, Registered Posts: 18 Partner
Hi,
I am creating a R script to read the dataiku project metadata from project path itself i.e. /DATA_DIR/config/projects/project_nm/params.json file. I am not able to understand the date forma used in the file i.e. 1581031993308. Could you please suggest what is this date format and if you have handy format function in R for this it would be very helpful ?
Best Answer
-
Hi,
This is a UNIX timestamp, i.e. the number of milliseconds since 1970-01-01T00:00:00.000Z
There are many ways to parse this in R:
- In base package:
as.POSIXct(1581031993308/1000, origin="1970-01-01", timezone="GMT")
- With anytime:
anytime(1581031993308/1000)
- With lubridate:
as_datetime(1581031993308/1000)
- In base package:
Answers
-
Thanks Clement !! That solves my problem.
-
Ankur5289 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 Partner
@Clément_Stenac
suppose we do not want the date to be transformed into this DSS defined date format in json file, what steps we should take?