Title: Database datetime fields issues
Last modified: December 2, 2020

---

# Database datetime fields issues

 *  Resolved [dennisdit](https://wordpress.org/support/users/dennisdit/)
 * (@dennisdit)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/database-datetime-fields-issues/)
 * My database server only allows one field with “CURRENT_TIMESTAMP” now. And this
   field needs to be “timestamp”. Is there any way I can make “created”, ” object_updated”,
   and “last_sync” work correctly? Also, my MySQL and Website seem not in the same
   time zone.
 * Any advice would be greatly appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/)
 * (@jonathanstegall)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/database-datetime-fields-issues/#post-13735510)
 * I think you’ll need to ask your host about this.
 *  Thread Starter [dennisdit](https://wordpress.org/support/users/dennisdit/)
 * (@dennisdit)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/database-datetime-fields-issues/#post-13736089)
 * Thank you very much for the quick response. I am running into another issue that
   is related to salesforce_id. I am wondering how salesforce_id is generated. The
   URL is something like this “services/data/v46.0/sobjects/Account/0014W00002AymX2TQY”,
   but the error is saying “invalid cross reference id”. Is this “0014W00002AymX2TQY”
   generated BY SF.
 *  Plugin Author [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/)
 * (@jonathanstegall)
 * [5 years, 5 months ago](https://wordpress.org/support/topic/database-datetime-fields-issues/#post-13799675)
 * This is a separate question that I don’t think is about datetimes, but yes, the
   ID is the unique identifier that every Salesforce record has.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database datetime fields issues’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/object-sync-for-salesforce.svg)
 * [Object Sync for Salesforce](https://wordpress.org/plugins/object-sync-for-salesforce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/object-sync-for-salesforce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/object-sync-for-salesforce/)
 * [Active Topics](https://wordpress.org/support/plugin/object-sync-for-salesforce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/object-sync-for-salesforce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/object-sync-for-salesforce/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Jonathan Stegall](https://wordpress.org/support/users/jonathanstegall/)
 * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/database-datetime-fields-issues/#post-13799675)
 * Status: resolved