在python中将日期计算为数字

from datetime import datetime

# 获取当前日期时间
now = datetime.now()

# 转换为时间戳
timestamp = now.timestamp()
print(timestamp)

from datetime import datetime

# 获取当前日期时间
now = datetime.now()

# 转换为儒略日
julian_day = now.toordinal() + 1721425.5
print(julian_day)

from datetime import datetime

# 获取当前日期时间
now = datetime.now()

# 转换为Excel序列号
excel_serial = (now - datetime(1899, 12, 30)).days
print(excel_serial)

import pytz
from datetime import datetime

# 设置时区
tz = pytz.timezone('Asia/Shanghai')

# 获取当前日期时间并指定时区
now = datetime.now(tz)

# 转换为时间戳
timestamp = now.timestamp()
print(timestamp)

from datetime import datetime

# 获取当前日期时间
now = datetime.now()

# 转换为Excel序列号，考虑1900年错误
excel_serial = (now - datetime(1899, 12, 30)).days
print(excel_serial)