ChatGPT to the rescue (format is MS OLE Automation Date format) - Python code to decode this:
from datetime import datetime, timedelta
def convert_ticks_to_datetime(ticks: int) -> datetime:
"""
Converts .NET ticks to a Python datetime object.
:param ticks: .NET ticks (100-nanosecond intervals since 1 Jan 0001)
:return: A Python datetime object
"""
ticks_per_second = 10_000_000 # 1 tick = 100 nanoseconds
net_start = datetime(1, 1, 1) # .NET epoch start date
# Calculate datetime by dividing ticks into seconds
converted_date = net_start + timedelta(seconds=ticks / ticks_per_second)
return converted_date
# Example usage
ticks_input = 638680529520944912
result = convert_ticks_to_datetime(ticks_input)
print(result) # Output: 2024-11-24 00:00:00
