You can translate the question and the replies:

Denodo time issue

Hi ALL, i am facing one issue , in one of the postgres table , i have data in datetime , when i am creating Base view and accesing data , the date is showing as '1970-01-01 12:11:11.000' but the date present in soure is '2020-01-01 10:11:00' Any help on this is really appreciated
user
02-06-2021 09:25:27 -0400
code

1 Answer

Hi, I was able to use a PostgreSQL data source to create a base view including some timestamps of the same format as yours, and successfully imported those without the data being changed. In my case, the data types of the columns in postgres and VDP were both timestamp (without timezone). While I can’t replicate your issue, I have some ideas: * Verify that the data types of the columns in Postgres and VDP are consistent e.g. both timestamp or timestamptz. * Check if you are seeing the same behavior in other tables or rows, where only the date is provided but not the time. * Furthermore, Denodo doesn’t store your data, rather it directly accesses it from the data source. With this in mind, if feasible, could you try exporting some of the rows from this table in postgres to an Excel file? Then, check if the dates are the same as what you have in the source. Hope this helps!
Denodo Team
02-06-2021 14:54:56 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here