LDAP, Active Directory & Filetime Timestamp Converter

The are different types of LDAP timestamps, 2 can be converted with the tools below:

Convert 18-digit LDAP/FILETIME timestamps to human readable date

The 18-digit Active Directory timestamps, also named 'Windows NT time format','Win32 FILETIME or SYSTEMTIME' or NTFS file time. These are used in Microsoft Active Directory for pwdLastSet, accountExpires, LastLogon, LastLogonTimestamp and LastPwdSet. The timestamp is the number of 100-nanoseconds intervals (1 nanosecond = one billionth of a second) since Jan 1, 1601 UTC.

The current LDAP/Win32 FILETIME is: 131846629790000000 (or 131846629790000000).

Enter number in full or in exponential notation:


Other converters

Microsoft Windows

In Windows (command line) use:

w32tm.exe /ntte 131001091660000000


(Get-Date 1/1/1601).AddDays(131001091660000000/864000000000)


Convert YMD LDAP timestamps

These LDAP timestamps are much more simple and start with the year. The timestamp has the following format: YYYYMMDDHHMMSST. T is the time zone which is usually 'Z' (Zulu Time Zone = UTC/GMT). The tool below can only handle Zulu timestamps.

The current timestamp is: 20181022062259Z

Enter your timestamp:


Comments and questions