Member since
04-16-2020
2
Posts
0
Kudos Received
0
Solutions
08-30-2022
07:30 AM
I have a date column thats a string and a separate time column thats a string I want to combine these into one column but can't get it to work. When I use this statement with hard coded values it works but when I plug in field names I just get null. from_unixtime(unix_timestamp('08-22-2022 15:25:42.23' ,'MM/dd/yyyy HH:mm:ss'), 'yyyy-MM-dd HH:mm:ss') however this doesn't work: ,from_unixtime(unix_timestamp(concat(cl_date , ' ', cl_time) , 'MM/dd/yyyy HH:mm:ss'), 'yyyy-MM-dd HH:mm:ss') f Should I not use concat?
... View more
Labels: