Using date in DataIKU

Niyazi

Hi,

Despite going through documentation multiple times, I still don't really understand how dates work in DSS. I'm importing dataset from a connection. Without turning on any of the options in Date & Time handling, this is how data looks like:

It says that the data type is string, while in the database itself it is, in fact, of type DATE.

Now, if I enable "Date & Time handling" checkboxes for our local timezone (Asia\Baku), I get this:

Which makes it date (if I update the schema tab), but puts date 4 hours behind. If I put timezone to "UTC", the date will display correctly. But only in this dataset. If I then do some work with it and store it in another dataset on a different connection (for example), I will see time difference again.

Hence, my question is this: how should I properly import dataset, so that I can both use appropriate data types, and have actual time and date information exactly as it is in the source database?

---

Operating system used: CentOS 7

---

Operating system used: CentOS 7

Alexandru

Hi @Niyazi ,

Since the time of this post, we've introduced support for more date types in DSS 13
https://doc.dataiku.com/dss/latest/release_notes/13.html#new-feature-new-handling-of-dates

If this doesn't address your concerns, can you please raise a support ticket with some current examples so we can advise further.

Thanks