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
In the database, dates are stored in UTC and does not know about time zones. And the export function only takes what it gets.