Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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