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.