Overview#Microsoft TIME is a mess. There are many different formats of Time or DateTime used within many different systems and some which are the same definition return different or truncated values. There is no consistency and no point of reference that we can find for an explanation.
Microsoft TIME LargeInteger Date#LargeInteger Date is one of the Microsoft TIMEs and may be referred to as FILETIME Microsoft Active Directory have a DateTime type (syntax) called LargeInteger which is defined the same as LargeInteger Date.
- all the msDS-(Attributes that are dates)
- all the msExch(Attributes that are dates)
MsSQL#But, MsSQL use the Unix Time format as I recall.
Microsoft Windows, the Client Operating System, counts the number of 100-nanosecond ticks since 12:00 A.M. January 1, 1601 Coordinated Universal Time (UTC) as reckoned in the proleptic Gregorian calendar, but only returns the current time to the nearest millisecond.
How to Convert Microsoft Time#From the command-line, on Vista and Windows 7 this worked.
w32tm /ntte time-as-an-integer
We also have used the on-line site Active Directory / LDAP Date ConverterMicrosoft Excel stores DateTime as NumericDate that represents the days since 1989-12-30. This is also the VB dateTime.