I have a Athenna sql query where i am calculating some delivery date like below.

”’ CASE
WHEN eventtime IS NOT NULL AND eventtime != ”
THEN
date_format(from_iso8601_timestamp(eventtime), ‘%Y-%m-%d %H:%i:%s’)
ELSE NULL
END as computation_date
”’

when i download the data as CSV and try to open in excel , i cannot see the Seconds values in the excel( due to some default format) , now fixing this , i am trying to concatenate the ‘ string to the date value so that the csv data will consider this as a string . i tried with Array agg and array join but its not working properly for me.

Also , i have a another where i have a value like 1.04567 , string value , i am trying to multiply with some constant value to the existing column , not sure how to achieve this also.

Regards,
San