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. 1601 Coordinated Universal Time (UTC). Microsoft Active Directory have a data type (syntax) called LargeInteger which is defined in a similar manner.
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.