Back to Aurora Vision Studio website

You are here: Start » Filter Reference » System » Time » DateTimeToTimestamp

DateTimeToTimestamp


Module: FoundationLite

Converts date and time to UTC timestamp.

Name Type Description
Input value inDateTime DateTime Date and time with timezone offset
Output value outTimestamp Timestamp UTC timestamp

Remarks

inDateTime.DayOfWeek field is ignored and computed from the other fields.

Assumptions about date and time calculations:

  • Timestamp should always be in UTC (Coordinated Universal Time).
  • Timestamp can be converted to DateTime using either UTC or local timezone. Other timezones are not supported. However, the timezone offset is saved in DateTime so one can always convert back to UTC.
  • Conversion to local time should take into account daylight saving time (summer/winter time), if configured in the operating system. However, usually only currently applicable DST rules are used, so calculations may be incorrect if they refer to a period when the rules were different.
  • Timestamp resolution is 100 nanoseconds.
  • Timestamp is 64-bit, so should support dates about 29000 years in the past or future. However, the whole range may not be supported when converting to local timezone.
  • Dates are calculated in proleptic Gregorian calendar.
  • Leap seconds are ignored, like in Unix time.

Errors

This filter can throw an exception to report error. Read how to deal with errors in Error Handling.

List of possible exceptions:

Error type Description
DomainError Date or time field out of range

Complexity Level

This filter is available on Basic Complexity Level.