You can translate the question and the replies:

ERROR: operator does not exist: timestamp without time zone >= character varying'

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 following error:ERROR: operator does not exist: timestamp without time zone >= character varying'. I have tried every workaround and I can not determine a solution, I am in need of help...In my derived view I want to have a date parameter where I can select records with a received date between date 1 and date 2. I am thinkning the timestamp is the underlying issue but my problem there is because the end user will be inputting a date only and not a timestamp and also because a timestamp is not releveant to what we are doing I am stuck on how to resolve this issue. Any help would be greatly appreciated. Thank you.
user
18-06-2018 15:43:14 -0400

1 Answer

Hi, There are a couple of things to do that I think will help. I will list below: 1. Edit the underlying base view and change the relevant date field to Field Type 'date' instead of 'timestamp'. 2. You can use the function *TO_DATE* for either your input variable or your query date parameter. This date function is listed [here](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#getday). There is also another thing I would like to bring up: you mentioned timezones, so please note that you can potentially get a different representation of a date field using Virtual DataPort Admin Tool if you use different timezone locales. An excellent read [here](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) goes into how to internationalize date configuration to avoid that potential problem. Hope this helps!
Denodo Team
19-06-2018 12:38:06 -0400
You must sign in to add an answer. If you do not have an account, you can register here