You can translate the question and the replies:

Teradata to denodo sql

how to convert the below syntax from teradata to denodo sql (DATE-1 - DAYOFMONTH(DATE-1))+1 (DATE-1 - Extract(Day from DATE-1))+1
user
03-08-2020 15:09:26 -0400

1 Answer

Hi, Virtual DataPort provides a variety of functions and in this scenario I would use different date functions to achieve my end result. I would write a VQL query using a combination of functions such as GETDAY, EXTRACT, CURRENT_DATE, etc. as needed. To know more about these functions, you could take a look at [Datetime Processing Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#datetime-processing-functions) section under the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
04-08-2020 07:16:22 -0400
You must sign in to add an answer. If you do not have an account, you can register here