35
Views
3
Comments
Solved
createDate inserting one day back date?

while creating a new record in account deatils entity, i am giving currentDate() function to save current date in the database,  but the problem is, while viewing that data in the application, its showing correct date ex; today date, but in the database its showing as one day back like yesterday. Suggestions please..

2019-01-07 16-04-16
Siya
 
MVP
Solution

Your database runs in a different timezone, most likely UTC, which may differ from the timezone of the machine you are using to access the application. The date and time displayed are automatically adjusted based on the timezone from which you access the application.

2022-07-11 14-05-36
Jeroen Barnhoorn
Solution

Does this occur throughout the day or only for records created early in the day? 

Keep in mind that the date stored in the database is the server's timezone, not your local timezone. This sounds like an issue that might have something to do with that.

2019-01-07 16-04-16
Siya
 
MVP
Solution

Your database runs in a different timezone, most likely UTC, which may differ from the timezone of the machine you are using to access the application. The date and time displayed are automatically adjusted based on the timezone from which you access the application.

2022-07-11 14-05-36
Jeroen Barnhoorn
Solution

Does this occur throughout the day or only for records created early in the day? 

Keep in mind that the date stored in the database is the server's timezone, not your local timezone. This sounds like an issue that might have something to do with that.

2026-03-19 06-05-04
Hemalatha Manikandan
Solution
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.