Driver Date Formats

ARDI drivers support several different date formats. Note that most formats will also require a timezone.

DateTime/TimeStamp

These are dates that conform to the SQL standard, in the format of YYYY-MM-DD HH:MM:SS. Your date stamps may include decimal seconds (ie. 09:12:54.22), but the date will be trimmed to remove everything after the decimal point.

This date format has advantages of being easily readable for both humans and computers.

Unix Epoch

This is the time in seconds since the 1st of Jan, 1972. This is the most common method of storing time in computer systems.

FILETIME

This is the total number of 'ticks' (each tick being 100 nanoseconds) since January 1, 1601.

This format is used internally by Windows to store file access times and is occasionally used in databases.

.NET Timestamp

This is the total number of 'ticks' (each tick being 100 nanoseconds) since 0AD.

This format is used internally by .NET applications on various platforms. It is occasionally stored to databases - for example, by CITECT.

This format is always in UTC. The timezone setting (if present) is ignored.