LDAP, Active Directory & Filetime Timestamp Converter
Maybe your like
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 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-nanosecond intervals (1 nanosecond = one billionth of a second) since Jan 1, 1601 UTC.
The current LDAP/Win32 FILETIME is 134168867120000000 or in scientific notation 13416886712e7.
Enter number in full or in scientific/exponential notation: Milliseconds are discarded (last 7 digits of the LDAP timestamp)
Convert 18-digit LDAP to dateCreate an 18-digit LDAP timestamp
| Yr | Mon | Day |
| - | - |
| Hr | Min | Sec |
| : | : | GMTLocal time |
| Create 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 20260302005832Z
Enter your timestamp:
Convert YMD LDAP to human date/epochComments and questions
Show commentsTag » Active Directory Pwdlastset Convert To Date
-
C# - How To Convert Active Directory PwdLastSet To Date/Time
-
Efficiently Converting Pwdlastset To Datetime In A Single Line.
-
How To Convert Date/time Attributes In Active Directory To Standard ...
-
Converting Pwdlastset To Datetime Datatype Not Working From Hash ...
-
Get-AdUser PwdLastSet - Get Aduser Last Password Change
-
How To Convert Active Directory Timestamp To Date In Excel (4 ...
-
PwdLastSet, AccountExpires, LastLogon, Timestamp LDAP / Active ...
-
Convert Active Directory PwdLastSet Attribute To Readable Time
-
Active Directory Date Long Integer PwdLastSet Conversion - DevCentral
-
Solved: How To Convert Dates From Data Source Active Direc...
-
TIP: Active Directory Module Date Properties - Tech Wizard
-
Convert PwdLastSet To A Human Readable Date
-
How To Convert Datetime <= To => Active Directory LDAP Win32 ...
-
How To Convert Active Directory Long Date In SDI/TDI - Forums - IBM