Q&A BY TAG 'timestamp'
oracle "date" column convert to "timestamp" column in Denodo
answered
15-12-2020 05:45:51 -0500
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
Data catalog change timestamp type fields format
answered
01-12-2020 07:06:36 -0500
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
Create new date field from a timestamp
answered
01-06-2020 03:45:27 -0400
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
Converting timestampz to epoch time
answered
06-02-2020 07:43:50 -0500
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
Timestamp Issue
answered
26-12-2019 17:40:21 -0500
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
ERROR: operator does not exist: timestamp without time zone >= character varying'
answered
19-06-2018 12:38:06 -0400
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
Subtracting two timestamps in Denodo
answered
12-09-2016 04:20:06 -0400
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