MariaDB : DateTime format doesnot have timezone while featching the data using VIEW

I have a scenario where I use exportEntityToExcel smart service to export a VIEW data (script below) in an excel file. There is one filed which has datatime (CREATED_ON) in it. I want to display/export to excel the timezone along with datetime in this field.

Existing Format: 11/27/23 02:43 

Expected Format: 11/27/23 02:43 AM/PM PST/CST/MST/EST 

.

CREATE VIEW `DUMMY_VW`  AS 
SELECT 
`b`.`CITY` AS `CITY`, 
`i`.`CREATED_ON` AS `CREATED_ON`, 
`i`.`CREATED_MONTH` AS `CREATED_MONTH`, 
`i`.`CREATED_YEAR` AS `CREATED_YEAR`, 
 FROM (`DUMMY_STATUS` `i` left join `DUMMY_PROFILE` `b` on(`i`.`ID` = `b`.`D_ID`)) ;

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data