Website not showing proper time


#1

hey guys! so i need some help with my cake application. Brief intro (it is a attendance system as well as a employee DTR. I use a hardware to get the attendance using RFID and Raspberry pi) I have problem in the outputs. Turns out that what my application (the site) outputs a different time or data with my stored data on database. I tried fixing my timezone, set it with my country (Philippines) but still it outputs a wrong time. What do you think is the problem? I really need your help guys, mu defense is 6 days from now TT.


#2

What’s in your database, what is it showing, and what code are you using to output it? Without such details, we could only guess.


#3

this is my output. what do you think is the error here?


#4


#5

Which column(s) should we be looking at? There’s 5 date columns in your database. And you still haven’t show us any of the relevant code.


#6

If I understood your issue correctly, you are tying to set the time zone of your application that corresponds to your local time. If this is the case, in your /config/bootstrap.php you have a line of code where you can set your timezone for your application.

/*
* Set server timezone to UTC. You can change it to another timezone of your
* choice but using UTC makes time calculations / conversions easier.
*/
date_default_timezone_set('America/New_York');

Check some more in the docs:
https://book.cakephp.org/3.0/en/views/helpers/time.html

And here you can check the list of supported timezones in PHP
http://php.net/manual/en/timezones.php

Hope this helps and happy coding !!