Q&A BY TAG 'date'

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