You can translate the question and the replies:

Unable to fetch data using date column having date data type

Hi , I have creates a view which consists of a column haviing data type as Date. I am not able to retrieve any data from this view when i am filtering the data based on the date column.
13-08-2018 03:11:14 -0400

1 Answer

Hi, I would ensure if the Date value being passed on the filter is in sync with the Source Type Properties of the date column. If required, I would also use TO_DATE and TRUNC functions to convert the filter value to the compatible type. You could refer to the related Q&A [Different Date Formats](, [Source Type Properties]( section of the Virtual DataPort Administration Guide, [TRUNC]( and [TO_DATE]( sections of the Virtual DataPort Developer Guide to get more details. Hope this helps!
Denodo Team
16-08-2018 00:12:36 -0400
You must sign in to add an answer. If you do not have an account, you can register here