I have a website being hosted overseas and I am having a problem with the date/timestamp on entries to the database captured by CFDB from a CF7 form.
The server time zone is UTC while the MySQL timezone is set to my local timezone (UTC+11) and the WordPress General Options timezone is also set to local time (UTC+11). The hosting company does not want to change the server time zone because that will affect all domains hosted there.
My difficulty is that CFDB entries are being date/timestamped in server (UTC) date/time instead of local time.
Is there an easy way I can get the CFDB records' "Submitted" field date/timestamped in the database with my local time, at the point when they are first recorded (i.e. I don't want to edit the Submitted field)?
Thanks in advance :-)