Likely to be caused by the difference in time-zone netween MySQL and ColdFusion. If so, then you can solve the problem by changing the setting for MySQL time-zone, ColdFusion time-zone or both.
I shall use my settings to illustrate.
Steps to change the MySQL time-zone setting:
Go to the Data Sources page in the ColdFusion Administrator;
(For the relevant MySQL datasource) Click on the button to edit the datasource settings, then on "Show Advanced Settings";
Enter the time-zone in the field "Connection String", using the MySQL driver attribute serverTimezone. In the example, I have entered my time-zone, which is Europe/Amsterdam; (If you want UTC time-zone, for example, use serverTimezone=UTC);
Press the Submit button to register the change.
Steps to change the ColdFusion time-zone setting:
Open ColdFusion's system file /bin/jvm.config in a text editor.
Add or, if it already exists, modify the -Duser.timezone flag in java.args. That is the time-zone that ColdFusion uses. For example, I want ColdFusion to use the same time-zone as MySQL. So, in my jvm.config file, java.args includes the flag -Duser.timezone=Europe/Amsterdam ; (If you want UTC time-zone, for example, use -Duser.timezone=GMT);
ColdFusion is then restarted for the change to take effect.
.
... View more