#整型日期的字符串转为年月日时分秒
import datetime
date_list = ["20240520", "20240521"]
datestart = datetime.datetime.strptime(date_list[0], '%Y%m%d')
dateend = datetime.datetime.strptime(date_list[1], '%Y%m%d')
print(datestart, dateend)
# 2024-05-20 00:00:00 2024-05-21 00:00:00
# 通过起止日期,补全中间的日期
Time = []
date_list = ["20240520", "20240521"]
datestart = datetime.datetime.strptime(date_list[0], '%Y%m%d')
dateend = datetime.datetime.strptime(date_list[1], '%Y%m%d')
while datestart <= dateend:
Time.append(int(datestart.strftime('%Y%m%d')))
datestart += datetime.timedelta(days=1)
#获取当前时间的整型日期
v_date = int((datetime.datetime.now() - datetime.timedelta(days=2)).strftime('%Y%m%d'))
print(v_date )
# v_date=20230206
# pyspark 日期修改列名,类型转换
df = sc.sql(hive_read).join(df_static_vin,on="t",how="left").\
select(["gpstimestamp"]).\
withColumnRenamed("gpstimestamp","gpstime").\
.withColumn("gpstime",(col("gpstime")/1000).cast(IntegerType()))
# 转换为长整型
# .withColumn("gpstime", col("gpstime").cast(LongType()))
python 时间格式处理
于 2024-05-27 11:34:26 首次发布