You can translate the question and the replies:


i have two field one for years and the other for month i want to combine the to one field of type timpstamp i used the function to_timestamp but it did not work
23-01-2023 16:36:21 -0500

1 Answer

Hi, I was able to combine a month field and a years field in a new field as a timestamp. I wrapped the 'to_timestamp' function around the 'concat' function for the month and years. For example, I created a selection view and add a new field with the value: ```to_timestamp('mmyyyy', (<month_column_name>|| <year_column_name>))``` The [Text Functions]( section of the Virtual DataPort VQL Guide will provide additional information on using ‘concat’. You could also refer to the section [Datetime Functions]( of the Virtual DataPort VQL Guide for more information about Date and time functions offered by Denodo Platform. Hope this helps!
Denodo Team
24-01-2023 17:12:53 -0500
You must sign in to add an answer. If you do not have an account, you can register here