Integer8 to Date
Convert Windows or Active Directory timestamps to UTC and your local time.
Choose an AD attribute to interpret its special values. Raw FILETIME treats zero as a date.
One complete decimal value per line. Up to 5,000 lines per batch.
ISO dates with all seven fractional digits preserved.
Time zone: your browser’s time zone. Local display uses millisecond precision where supported.
Loading converter…
Blank or invalid input lines stay blank in both outputs. Conversion happens in your browser; this tool does not upload or save your values.
Timestamp formats and special values
FILETIME counts 100-nanosecond intervals from 1 January 1601 UTC. Paste the full decimal integer, not scientific notation, hexadecimal, or a Unix timestamp.
In accountExpires mode, 0 and 9223372036854775807 mean “Never expires”. In lastLogon mode, 0 means the logon time is unknown. Other attributes may assign different meanings to special values.
Negative Integer8 values can represent intervals or attribute-specific commands; they are not supported as timestamps here. This converter does not query Active Directory.
The Windows Time Stamp Format - aka Integer8
Microsoft Windows environments use the Integer8 timestamp format. A 64-bit value representing the number of 100-nanoseconds elapsed since January 1, 1601 (UTC).
Conversion with PowerShell
PS C:\> Get-ADUser Alice -Properties * | fl lastLogon
lastLogon : 132463843855875757
# Convert to Local time
PS C:\> [datetime]::FromFileTime("132463843855875757")
05 October 2020 16:13:05
# Convert to UTC time
PS C:\> [datetime]::FromFileTimeUTC("132463843855875757")
05 October 2020 15:13:05
Comments