Handling Phone Numbers and Date Formats

Data Cloud ensures consistency in how phone numbers and dates are stored, processed, and shared across systems.

Phone Number Storage

Phone numbers are always stored and sent in E.164 format via API.

Note:

For TMO the input numbers are assumed to be US numbers and any invalid numbers are not stored.

Date and DateTime Formatting

All dates and timestamps in Data Cloud are stored in UTC. The storage formats follows these standards:

• Datetime values are stored as yyyy-MM-dd'T'HH:mm:ss.SSS'Z' (Example: 2024-12-11T14:30:00.123Z).

• Date values are stored as yyyy-MM-dd (Example: 2024-12-11).

When sending data via API or S3, different input formats are supported, but the stored and returned values always stick to the standard. If the input does not match one of the accepted formats, it gets ignored.

Here is how the accepted formats look like:

• yyyy-MM-dd'T'HH:mm:ss → 2024-12-11T14:30:00

• yyyy-MM-dd'T'HH:mm:ss.SSS → 2024-12-11T14:30:00.123

• yyyy-MM-dd'T'HH:mm:ssZ → 2024-12-11T14:30:00Z

• yyyy-MM-dd'T'HH:mm:ss.SSSZ → 2024-12-11T14:30:00.123Z

• yyyy-MM-dd → 2024-12-11

By keeping these formats consistent, Data Cloud ensures data stays accurate and works smoothly across different platforms.