How to create a new column by combining two column in Spark SQL?

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65948126/how-to-create-a-new-column-by-combining-two-column-in-spark-sql

Answer 1

You should be able to use:

select t.*,
       (no || ' ' date_format(date_time, 'hh:mm:ss')) as new_col
from t;