CA Application Lifecycle Conductor

Expand all | Collapse all

How to sync a date/time field in unixtimestamp

Jump to Best Answer
  • 1.  How to sync a date/time field in unixtimestamp

    Posted 08-02-2017 05:18 PM

    We're trying to sync a field date in SDM (this is a timestamp). Could we use this to sync with an ALC Date/Time type Attribute?

     

    Ex: 

    SDM Field -- need_by (Nedd By date) this is a SDM DATE field on SQL this field is tye INT

    ALC Field  -- new custom attribute field type Date/Time this field in SQL is type datetime2

     

    Thanks for your help.

    Regards,

    JOHN



  • 2.  Re: How to sync a date/time field in unixtimestamp
    Best Answer

    Posted 08-11-2017 09:59 AM

    Hi John,

    The SDM connector should convert the SDM API format to a java.util.Date in the connected object so you should have no issue sync'ing an ALC date/time field.

    Vaughn