Q&A BY TAG 'Date'

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

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


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 Date SQLServer 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

specifying custom i18n on scheduler extractor for csv
answered 11-11-2016 08:16:02 -0500

I have specified a custom i18n and am trying to apply this to an extractor btu so far have been unsuccessful. I have tried the following. Setting the i18n on the base view Setting the i18n on the final view Specifying the i18n during the query in the...

Answers: 1

scheduler date csv export i18n

answered 07-09-2016 10:47:51 -0400

when i load the date field in denodo it shows like 'wed dec 17 00:00:00 IST 1980' but i have given only 'yyyy-MM-dd' in database. How to display date with format 'yyyy-MM-dd' in date datatype only as when i am using formatdate() function it changes the...

Answers: 1

date functions dateformat datatypes

DATE with Time Is not Matching
answered 12-08-2016 09:08:34 -0400

Hi Team, I am running Denodo testing tool to test the query in Denodo 5.5 and Denodo 6. I am getting all columns value same but not for date column. in Denodo 6 : Mon Aug 01 00:00:00 MDT 2016 in Denodo 5.5 : Mon Aug 01 12:26:14 MDT 2016 I am gettin...

Answers: 3

denodo 6.0 Date

How do I store "2014-12-31" as just a date, without the time and without a timezone?
answered 01-09-2015 10:08:11 -0400

Hi, I have a 3rd party web service that returns "2014-12-31" as one of the field values and I'd like to store it as a date in Denodo, (not a datetime: I don't want any timezone information stored nor time information... I just want the date). Can I s...

Answers: 1

date data types

Syntax for a Condition: Last Ten Years
answered 13-08-2015 04:08:01 -0400

Hello, Here is my current condition: todate('MM/dd/yyyy', ITEM.datefiled) >= todate('MM/dd/yyyy','08/12/2005') I would like to modify this so that it will only bring back the last ten years from whatever date it is currently. Thank you

Answers: 1

date itpilot condition field syntax