Field Data Types: Salesforce CRM's Contact object fields can store data in various formats. When ingesting data into Salesforce Data Cloud, the target field's data type determines how the data is processed and stored.
Date Data Type: If the target field in Data Cloud is set to Date data type, it is designed to store date values without time information.
Mixed Format Values: When ingesting a field containing both date (yyyy-mm-dd) and datetime (yyyy-mm-dd hh:mm:ss) values into a Date data type field:
The Date field will extract and store only the date part (yyyy-mm-dd), ignoring the time part (hh:mm:ss).
Result:
Date Values: yyyy-mm-dd values are stored as-is.
Datetime Values: yyyy-mm-dd hh:mm:ss values are truncated to yyyy-mm-dd, and the time component is ignored.
References:
Salesforce Data Cloud Field Mapping
Salesforce Data Types