Thank you, that is exactly what I ended up with. CDR now shows local time but 12/24 hours time display is most likely hardcoded there.Hello,
Try changing the time zone in your user settings. Keep your OS time always as UTC. This way each user can have their time zone set individually. I hope this helps.
$sql .= "to_char(timezone(:time_zone, start_stamp), 'DD Mon YYYY') as start_date_formatted, \n"; $sql .= "to_char(timezone(:time_zone, start_stamp), 'HH12:MI:SS am') as start_time_formatted, \n";