Database datetime fields issues

  • Resolved dennisdit

    (@dennisdit)


    3 years, 12 months ago

    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

    (@jonathanstegall)

    I think you’ll need to ask your host about this.

    Thread Starter dennisdit

    (@dennisdit)

    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

    (@jonathanstegall)

    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.