Hi team, I have view sourced from oracle, which contains date type column, when created this view, denodo converted the date column to "timestamp" automatically, and when tried to convert it to "localdate", the error is showing "the field has an incomp...
Answers:
1
Hello, Currently when we query views containing fields of type "timestamp" in our Data Catalog, the data in these fields is formated in an odd way like the following example: Mon Dec 05 09:52:00 2005 When querying the same view through the VDP...
Answers:
3
Hi. I have two views in Denodo (in different datebases). I want to join the two on date (and another ID). However, the views do not have date, they only store timestamp. I want to get just the date from the timestamp in both views and join them. Here ...
Answers:
2
Hi, I have seen previous enquiries about a function to convert to and from epoch time before. Are there any possibility that this function will be prioritized in future patches? The autogenerated column "expirationDate" uses epoch time for the expirat...
Answers:
1
Hi, During our PoC with Denodo, we faced some issues related with Timestamp-NTZ and Timestamp-LTZ column types. When we include these fields in Base View (or SQL based Base View) columns are mismatching. Basically, denodo cannot determine the column(s...
Answers:
1
Hello, I am new to Denodo and because I have a strong background in SQL I have been using my SQL skills by creating base views off a query. When I get to the next step of creating my derived view witha a date parameter I continue to receive the followi...
Answers:
1
Hi Support Is it possible to subtract two timestamps in Denodo to get the Day/Hour/Minute/Second difference between the two fields? I don't see a function for it and was having troubles breaking it out with 'get' commands. Thanks!
Answers:
3