CFDB Time Zone Issue

  • Resolved Gillian

    (@ridgididgi)


    11 years, 9 months ago

    Hi Michael

    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 ??

    https://www.ads-software.com/extend/plugins/contact-form-7-to-database-extension/

Viewing 4 replies - 16 through 19 (of 19 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    And what is the setting in Settings -> General -> Timezone ?

    Oh man! I’m so sorry. I didn’t have that set right, it was UTC-6. I thought I had checked that but I think because I saw the “local time is …” and the time format in the right time that I had it set.

    Thank you for being so helpful and for the quick response. I really appreciate it!

    As noted in my original post, I already have my WordPress timezone in [link to non-WordPress site moderated] Admin > General Settings set to UTC+11. The problem is that the timezone being used by CFDB is UTC+0 (i.e. GMT) which is the server timezone.

    Can you set it to a city? I set mine to Chicago and it works great. It even changed the previous entries to the correct time.

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘CFDB Time Zone Issue’ is closed to new replies.