Hello, I have a problem after the ColdFusion 2021 ...
# adobe
i
Hello, I have a problem after the ColdFusion 2021 hotfix 13 update: This simple MySQL 8 query:
Copy code
UPDATE
	tableName
SET
	registrationDate = {ts '2024-04-10 00:00:00' }
WHERE
	pk = 1
Updates registrationDate to
2024-04-09
(one day back). And it does so for every day starting from the month of April. For the months before April, it works correctly. Why do you think that is? I tried running the query from DBeaver and it executed correctly.
q
Is the timezone of the SQL server set to the same as your CFML server? I think there is also a timezone setting on the MySQL driver too.
a
Are you using cfqueryparam ?