Title: CFDB Time Zone Issue Last modified: August 20, 2016 --- # CFDB Time Zone Issue * Resolved [Gillian](https://wordpress.org/support/users/ridgididgi/) * (@ridgididgi) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/) * 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 🙂 * [http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/](http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/) Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/topic/cfdb-time-zone-issue/page/2/?output_format=md) [→](https://wordpress.org/support/topic/cfdb-time-zone-issue/page/2/?output_format=md) * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504835) * You can change the WordPress timezone in the Admin -> General settings. I think the plugin pulls the timezone settings from that (I’d have to check to be sure). If you set WP to the TZ you want, does that work? * Thread Starter [Gillian](https://wordpress.org/support/users/ridgididgi/) * (@ridgididgi) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504836) * Hi Michael * Thanks for the speedy reply 🙂 * As noted in my original post, I already have my WordPress timezone in 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. * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504837) * I missed that. I can’t think of anything else you can do to change the timezone of the submit time. * Thread Starter [Gillian](https://wordpress.org/support/users/ridgididgi/) * (@ridgididgi) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504839) * Would it be possible for me to make a change to the plug-in code for the submit time to be pulled from the WordPress timezone instead of the server timezone? I would think I’m not the only one experiencing this issue. * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504841) * You would have to replace various `date_default_timezone_set(get_option('timezone_string'));` lines in the code with the timezone you want. It’s not configurable right now. * Thread Starter [Gillian](https://wordpress.org/support/users/ridgididgi/) * (@ridgididgi) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504842) * Hi Michael * If you could possibly tell me which plug-in files I’d need to edit I’ll give it a go. * Many thanks. * Thread Starter [Gillian](https://wordpress.org/support/users/ridgididgi/) * (@ridgididgi) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504866) * Hi Michael * Just reporting back that I have resolved the problem, and the database entries are now correctly recorded in local time. * Thanks for your help. * [lassiebun](https://wordpress.org/support/users/lassiebun/) * (@lassiebun) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504951) * I am having the same issue. Gillian, can you please respond with the step you took to fixed this? * Thanks, * Karla * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504981) * I added a way to set this in the Database Options panel. I just need to push out an update of the plugin. Will do later today * [lassiebun](https://wordpress.org/support/users/lassiebun/) * (@lassiebun) * [13 years, 5 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3504990) * Michael, * Thank you so much for adding this option. It is greatly appreciated and my client is super pleased! * Keep up the great work! * Karla * [jodzeee](https://wordpress.org/support/users/jodzeee/) * (@jodzeee) * [13 years, 3 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3505062) * I’m confused. I found the option to change it, but it says if left blank, it will pull from the timezone set in WordPress. Is that not true? * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [13 years, 3 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3505063) * That is the expected behavior. Be sure there are no blank spaces in that field. * [jodzeee](https://wordpress.org/support/users/jodzeee/) * (@jodzeee) * [13 years, 3 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3505064) * I’m not sure we’re talking about the same thing. The field is blank by default and the text says, “Timezone to capture Submit Time. Blank will use WordPress Timezone setting.” * But that’s not how it works. If I leave it blank, it’s not giving me the right time. * [screen-grab](https://dl.dropboxusercontent.com/u/12289996/5-24-2013%2012-21-01%20PM.png) * Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/) * (@msimpson) * [13 years, 3 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3505065) * You are saying that it is not giving the correct time, but you are not saying what it is actually giving you. If blank, it should be giving you the time in the timezone set in Setting -> General -> Timezone. If you don’t get that, what do you get? * [jodzeee](https://wordpress.org/support/users/jodzeee/) * (@jodzeee) * [13 years, 3 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/#post-3505066) * Sorry … if I leave it blank, the time it’s outputting is 5 hours ahead. It’s 12:50 here now, but when I fill out a form and look in the DB, it says 17:50. Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/topic/cfdb-time-zone-issue/page/2/?output_format=md) [→](https://wordpress.org/support/topic/cfdb-time-zone-issue/page/2/?output_format=md) The topic ‘CFDB Time Zone Issue’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff. svg) * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/) * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq) * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/) * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/) * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/) ## Tags * [cfdb](https://wordpress.org/support/topic-tag/cfdb/) * [time zone](https://wordpress.org/support/topic-tag/time-zone/) * [timestamp](https://wordpress.org/support/topic-tag/timestamp/) * 19 replies * 5 participants * Last reply from: [jodzeee](https://wordpress.org/support/users/jodzeee/) * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/cfdb-time-zone-issue/page/2/#post-3505070) * Status: resolved