You can translate the question and the replies:

to_date(to_char) version 6

Hi My oracle function is to_date(to_char(b.X,'DD-MON-YY hh24:mi:ss'),'DD-MON-YY HH24:mi:ss') How i am suppose to implement this in denodo? Any help
12-12-2018 20:34:42 -0500

1 Answer

Hi, In that specific case you could use a combination of the functions formatdate and to_date. You can first use the formatdate function to get a string of a date value with the specified pattern and then use the to_date function to convert it back to a date type. You will find the syntax and an overview about these two functions in the article [Date Processing Functions ]( from the documentation and you will find more information about the date patterns in the article [Date and Time Pattern Strings]( Hope this helps!
Denodo Team
13-12-2018 05:20:29 -0500
You must sign in to add an answer. If you do not have an account, you can register here