mysqldump or export to csv in a different timestamp format

MySQL & MariaDB Percona XtraDB Cluster 5.x
4

I need to add the format for DATE datatype too , when i tried to use ELSEIF for the above quey , it gives me syntax error. Can you please suggest how to incorporate the date datatype also ? I tried as below -

if(DATA_TYPE=‘timestamp’ then concat(‘DATE_FORMAT(’,COLUMN_NAME,‘,“%d-%b-%y %l.%i.%s %p”)’),COLUMN_NAME) as COLUMN_NAME

elseif(DATA_TYPE=‘date’ then concat(‘DATE_FORMAT(’,COLUMN_NAME,‘,“%d-%b-%y”)’),COLUMN_NAME) as COLUMN_NAME) as COLUMN_NAME

end if