LDAP, Active Directory & FILETIME Timestamp Converter
There are at least 2 types of LDAP timestamps, an 18-digit timestamp and a timestamp that is based on a Year-Month-Day format.
Convert 18-digit LDAP/FILETIME timestamp to human-readable date
The 18-digit Active Directory timestamps, also named 'Windows NT time format', 'Windows FILETIME', 'Win32 FILETIME', '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-nanosecond intervals since Jan 1, 1601 UTC (1 nanosecond = one billionth of a second).
The current LDAP/Win32 FILETIME is 134184165950000000 or in scientific notation 13418416595e7.
Enter number in full or in scientific/exponential notation:
Milliseconds are discarded (last 7 digits of the LDAP timestamp)
Create an 18-digit LDAP timestamp
Other converters & programming
Microsoft Windows
In Windows (command line) use:
w32tm.exe /ntte 131001091660000000
PowerShell
(Get-Date 1/1/1601).AddDays(131001091660000000/864000000000)
Convert YMD LDAP timestamps
These LDAP timestamps are much simpler 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 YMD timestamp is 20260319175635Z
Enter your timestamp: