You can translate the question and the replies:

Denodo Equivalent function

Hi I have a teradata query : to_char(cast("joining_date" as timestamp ), 'MonthYYYY') as Joiningdate what is the equivalent I can give in denodo so that the above query runs. Thank you
user
23-11-2023 02:12:39 -0500
code

1 Answer

Hi, I would try the following query to convert a date value to a string in the format 'MonthYYYY' in Denodo. > cast(formatdate('MMMMyyyy',to_timestamp('yyyy-MM-dd',<date_field>)) as text) Hope this helps!
Denodo Team
23-11-2023 07:35:28 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here