Convert ActiveDirectory timestamp into regular one. Arrow (solved)

Thread Rating:

Thread Modes

Convert ActiveDirectory timestamp into regular one. Arrow (solved)

bowlofred
Da Bishop

Posts: 1,566

Threads: 3

Joined: Mar 2020

Reputation: 165

Nov-02-2020, 08:34 AM

Divide by 10000000, subtract 11644473600, and feed that in as a unix timestamp.

>>> arrow.get(132556896000000000/10000000 - 11644473600)
<Arrow [2021-01-21T08:00:00+00:00]>

SpongeB0B likes this post

Messages In This Thread

RE: Convert ActiveDirectory timestamp into regular one. Arrow (solved) - by bowlofred - Nov-02-2020, 08:34 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	[SOLVED] Correct way to convert file from cp-1252 to utf-8?	Winfried	8	913	Feb-29-2024, 12:30 AM Last Post: Winfried
	[SOLVED] Epoch timestamp without milliseconds?	Winfried	5	3,043	Jan-27-2023, 04:35 PM Last Post: deanhystad
	Convert an Interger into any base !? [Solved]	SpongeB0B	8	1,435	Jan-16-2023, 10:24 AM Last Post: SpongeB0B
	[SOLVED] Alternative to regex to extract date from whole timestamp?	Winfried	6	1,852	Nov-16-2022, 01:49 PM Last Post: carecavoador
	error in timestamp	Led_Zeppelin	3	3,242	Jun-15-2022, 08:28 PM Last Post: deanhystad
	error in timestamp	Led_Zeppelin	0	1,016	Jun-10-2022, 07:59 PM Last Post: Led_Zeppelin
	\|SOLVED] Glob JPGs, read EXIF, update file timestamp?	Winfried	5	2,502	Oct-21-2021, 03:29 AM Last Post: buran
	Convert date integers (ex. 43831) to regular format	Galven	2	2,643	Nov-15-2020, 11:38 PM Last Post: bowlofred
	How to convert different timestamp formats?	python_newbie09	12	6,913	Aug-05-2019, 06:37 PM Last Post: python_newbie09
	Timestamp is undefined	ErnestTBass	7	7,971	Feb-16-2019, 08:27 PM Last Post: snippsat

Users browsing this thread: 2 Guest(s)