python随机生成一个符合bigquery的timestamp类型的字符串
可以使用Python的datetime和random模块来生成符合bigquery的timestamp类型的字符串:
import datetime
import random
# 生成一个随机的日期
year = random.randint(2000, 2021)
month = random.randint(1, 12)
day = random.randint(1, 28)
hour = random.randint(0, 23)
minute = random.randint(0, 59)
second = random.randint(0, 59)
microsecond = random.randint(0, 999999)
# 构造datetime对象
dt = datetime.datetime(year, month, day, hour, minute, second, microsecond)
# 转换为符合bigquery的timestamp类型的字符串
timestamp_str = dt.strftime('%Y-%m-%d %H:%M:%S.%f')
# 打印结果
print(timestamp_str)
输出示例:
2013-07-12 23:05:45.245678
``
原文地址: https://www.cveoy.top/t/topic/dxnK 著作权归作者所有。请勿转载和采集!