Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
OK, this is weird... I am calculating a firstOfMonth value that shows up properly in the last tLog before inserting into MySQL:
2019-01-06
2019-01-07
2019-01-08
2019-01-09
But when I query the database, all 4 of those show up as:
2019-05-31
2019-06-30
2019-07-31
2019-08-31
What the heck?
This may be due to the default timezone used by MySQL.
This link may help you https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql
