search

phpLiteAdmin / pla

Official github clone of the phpLiteAdmin repository
https://www.phpliteadmin.org/
173 stars 36 forks source link

phpliteadmin.php - datetime and dt_tz #36

Open Lumi05 opened 1 year ago

Lumi05 commented 1 year ago

Hello, I work with EasyIO PLCs which integrate an SQL database. In the phpliteadmin.php file, I've noticed that there's a two-hour time difference between the recording of the data and the time shown in the DB Manager. I'm in France.

Could you tell me more about this? I suspect it's due to the date format, which doesn't take into account the time zone I'm in. "date_format" => 'g:ia o\n F J, Y (T)

How can I integrate the time zone difference? Thanks !!

Dygear commented 1 year ago

PHPLiteAdmin should use the local time of the device it's on by using the php.ini file. 

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
;date.timezone =