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
The problem was in both versions. I just checked that. I had to sett the timezone in database connection to UTC and not local. That fixed the problem with the time showing wrong time. But still I have that anoying Z and T in the database result.
