|
<< Click to Display Table of Contents >> Navigation: Reference > Column types > DateTime |
DateTime values follow the ISO standard:
yyyy-MM-ddTHH:mm:ss.zzz[Z|[+|-]HH:mm]
Where:
•yyyy is the year as a four digit year
•MM is the month as number with a leading zero (01 to 12)
•dd is day as number with a leading zero (01 to 31)
•T is the character 'T' (date/time separator)
•HH is the hour with a leading zero (00 to 23)
•mm is the minute with a leading zero (00 to 59)
•ss is the second with a leading zero (00 to 59)
•zzz is the milliseconds with leading zeroes (000 to 999)
•Z is the character 'Z' (for UTC)
•[+|-]HH:mm is the offset from UTC
The following are valid datetimes:
•2026-04-23T15:21:41
•2026-04-23T15:21:41.000
•2026-04-23T15:21:41+01:00
•2026-04-23T15:21:41-12:00
•2026-04-23T15:21:41Z
•2026-04-23T15:21:41.000Z
•2026-04-23
A 'Z' at the end of the datetime means that the datetime is in UTC (Coordinated Universal Time, also known as Zulu time or Greenwich Mean Time). Otherwise the datetime is local time.
You can convert to/from datetime format using the DateTime format transform.
You can perform calculations on columns of datetime values using the following operations in the Calculate transform:
•DateTimeAddDays
•DateTimeAddHours
•DateTimeAddMonths
•DateTimeAddMSecs
•DateTimeAddSecs
•DateTimeAddYears
•DateTimeToMSecs
•DateTimeToUTC
You can use the MSecsToDateTime operation in the Calculate transform to convert the number of milliseconds since 1970-01-01T00:00:00.000 UTC to a datetime.
•Date