Q&A BY TAG 'datetime'

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

Postgres ADDDAY translates, but other ADD datetime functions do not
answered 07-05-2021 17:25:37 -0400

We recently started using a Postgres connection in Denodo. We've noticed that on larger datasets (particularly in joins) that performance is impacted when using the ADDMONTH function. ADDMONTH can't be delegated to the data source since it's not a Post...

Answers: 1

datetime PostgreSQL Date time function

INSERT Operation fails with multiple records and the now() function
answered 15-04-2021 07:26:17 -0400

I'm performing a simple Insert Operation with multiple records using the now() function. insert into "ViewName" ("Id", "Name", "EmailAddress", "EmailDtm") values ('1', 'joe', 'joe@denodo.com', now()), ('2', 'joe', 'joe@denodo.com', now()) It throws a...

Answers: 1

datetime Insert Operation

SQL Server date datatypes error in conversion for base views
answered 15-06-2020 04:04:07 -0400

¬°Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...

Answers: 1

Date Conversion datetime Base view Error SQL Server

Base View date field is populating incorrect format
answered 04-11-2019 13:50:34 -0500

Hello, We have a base view that is populating a date field incorrectly. The date field should be populated under the format of date time with the time being zeros (example Tue Jul 29 00:00:00 EDT 1947) , however for a number of recrods we are seeing Tu...

Answers: 3

datetime locale date field