Problem with datetime data from mysql allways returned in utc coding and not local time Bug Report #1656668247093

OS info

Problem description

Problem with datetime data from mysql allways returned in utc coding and not local time
I allways get a return of utc coded time when i use a sql to mysql. It show 2 hours wrong and it utc format. I have set local timezone in database connoction. And wappler is the only that returns utc code on the time

Steps to reproduce

1.select rom_id, start, stopp, tekst from bedrift_enkunde_ensted_rom_tider
where rom_id = :p1
2.
3.
I have to use this sql code to get he right time
select rom_id, date_format(start,’%d-%m-%Y %H:%I’), date_format(stopp,’%d-%m-%Y %H:%I’), tekst from bedrift_enkunde_ensted_rom_tider
where rom_id = :p1

Community Page
Last updated: