You should be able to use:
select t.*, (no || ' ' date_format(date_time, 'hh:mm:ss')) as new_col from t;
1.4m articles
1.4m replys
5 comments
56.9k users