Instant to MS Date Transformer

This page describes the Instant to MS Date Transformer Pipes valve and its supported options.

Note

The Microsoft (MS) date format represents dates as the number of 100-nanosecond intervals (also known as ticks) that have elapsed since January 1, 1601, UTC. This date is known as the MS epoch and is used extensively in Windows systems, including file times and Active Directory attributes like accountExpires.

Configuration

Note

Valve name: InstantToMsDateTransformer

Properties

Name	Description	Default	Mandatory	Expanded
src	Property containing the source Instant.	N/A
src_pattern	Instant pattern. ISO-8601 format	"yyyy-MM-ddTHH:mm:ss.ffffffZ"
src_tz	Instant time zone.	"UTC"
dest	Property containing the created MS Date	N/A
remove_existing_dest	Flag to remove any value pre-existing in destination-property. To avoid creating a multi-value property.	false

Example

{
    "name": "InstantToMsDateTransformer",
    "config": {
        "src": "instant",
        "src_pattern": "yyyy-MM-ddTHH:mm:ss.ffffffZ",
        "src_tz": "GMT-1",
        "dest": "ms_date"
    }
}

Special handling of 'Never Expires'

If the src value is "0" the valve interprets this as an account that never expires. In this case, the output at dest will be set to 9223372036854775807 (0x7FFFFFFFFFFFFFFF)