You can translate the question and the replies:

to_timestamp

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
user
23-01-2023 16:36:21 -0500
code

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](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/functions/text_functions/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](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/datetime_functions/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
code
You must sign in to add an answer. If you do not have an account, you can register here