Hi,
Denodo date types always use the timezone information. If you need to use a text value, e.g. "2014-12-31", as a date value to execute conditions over dates, you need to convert this field to a date. To get this, you can use either the TO_DATE function or you can import the field changing the type to date, if the field has a format that is compatible with the i18n used for that view.
The section "TO_DATE" of "the Advanced VQL Guide" contains information about how to use the TO_DATE function. You can use the parameter "timestamp" with the value "false", so the function sets to 0 the fields that represent the time.
Keep in mind that, as date types include timezone information, you can get a different representation of a date field using VDP admin tool if you use different Locales and the option "Internationalize query results". There is more information available about the "Internationalize query results" in the section "Locale" of the Virtual DataPort Administration Guide.
Hope this helps!
