Q&A BY TAG 'date'

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

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