Q&A BY TAG 'Date'

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

Date Data Type Issue
answered 08-11-2019 19:05:52 -0500

Hi Team, Please share Denodo 6.0 Manaul URL where I can read about Denodo Data types I have a SQL Server Table, which has fields in date data type. When I create base view, those date fields are converted to text. Why ? How to keep them in date ...

Answers: 1

Date datatypes

Get list of dates between two dates
answered 27-06-2019 05:45:54 -0400

How can I fetch all the list of dates between two dates ? Is there a system calendar that I can refer too ?

Answers: 1

Date

Filtering between Current_Date and Current_Date - x days
answered 24-08-2018 10:49:12 -0400

I'm looking to filter a query by dates. The date (my_dt) within the table I'm pulling from is in the format yyyyMMdd but as type numeric and length of 8. So, what I'm trying to do is filter where my_dt is between a date that is x days ago from today an...

Answers: 1

Date Conversion Date

Date Format Transformation Pass Through Query in SAS
answered 22-08-2018 12:01:56 -0400

Hello, I have created a query in SAS that passes through Denodo via odbc connection (uses VQL syntax). My input date (effdate) is numeric with a length of 8 and looks like 20180815. I have tried numerous ways of converting it to a date. No matter what...

Answers: 3

Date Conversion TO_DATE TO_DATE function Date

Date Formatting
answered 21-08-2018 14:22:36 -0400

Hello, Here is my issue. I am working in Alteryx, pulling a table from Denodo. I'm looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I'm looking to convert are like such. 9101...

Answers: 4

Date Conversion Date

Odd Date Conversion
answered 01-08-2018 06:37:04 -0400

Hello, I’m looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I’m looking to convert are like such. 910101 is an example of the date value. This is equivalent to Jan 1, 1991. B...

Answers: 1

Date Conversion Date

How do you subtract two dates to get the duration in days
answered 26-06-2018 13:31:37 -0400

in Oracle we would use select (end_date - start_date) from dual Update - it looks like the getdaysbetween(date1, date2) function may work for me

Answers: 2

Date

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

Datatype Issue while creating a base view from SQL Server
answered 10-05-2018 03:00:38 -0400

I have a table in Sql server with a column of date datatype. For this instance : Create table table_name ( dob date ) ; I have created base view on top of this table. But in base view, datatype of dob as text datatype in denodo which is not expected...

Answers: 1

DENODO MSSQL SQLServer Date sql server datatypes

Having an issue with the MIN function for Date data types
answered 05-02-2018 12:43:07 -0500

I am getting the wrong value in the result-set when when querying a Date value. The incoming data type listed in the Base View is "date" (the Base view matches the data source tables exactly). I use the MIN function in a grop-by query: select MIN(<...

Answers: 1

MIN function Date