Q&A BY TAG 'timestamp'

You must sign in to ask a question. If you do not have an account, you can register here

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

Date timestamp

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

Interpolation Variables Epoch time timestamp

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

snowflake Base view DENODO timestamp

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

query Parameter Date timestamp

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

timestamp