Hello,
Dates in mongo are stored in UTC bij default. Representation of dates in Dremio are in UTC too ? Is this correct ? Doesn’t the front-end follow the Locale of the client/browser ?
For example :
date in MongoDB (UTC) 2017-10-31 23:00:00.000Z.
In the timezone (Europe/Paris) this is 2017-11-01 00:00:00.000
Showed in Dremio front-end as 2017-10-31 (running in the user.timezone Europe/Paris)
Exported in excel (via ODBC) as 2017-10-31
Greetings,
Alain Caluwaerts