Shulou(Shulou.com)06/02 Report--

Editor to share with you how to use python to convert the number of days into a date string, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Python number of days to date string

When reading Excel using python, the cell in date format reads out a number that represents the number of days from January 01, 1990 to that date.

For example, the number read is: 44570, in fact, the date in Excel is: 2022-01-09

The main function of the following function is to convert the number of days to date string format

#! / usr/bin/python#-*-coding: UTF-8-*-"" @ author: Roc-xb "" from datetime import datetimefrom xlrd import xldate_as_tuple''function: format the number of days as a date string: represent the number of days from 1990-01-01 to a certain day' 'def days_to_date_str (days): real_date = datetime (* xldate_as_tuple (days) 0). Strftime ('% Ymuri% mmurf% d') print (real_date) return real_date if _ _ name__ = ='_ main__': days = 44570 days_to_date_str (days)

The output result of the program:

Attachment: convert the time of a string to a timestamp a = "2013-10-10 23:40:00" # convert it to a time array import time timeArray = time.strptime (a "% Y-%m-%d% H:%M:%S") # converts to a timestamp timeStamp = int (time.mktime (timeArray)) timeStamp = = 1381419600 is all the content of the article "how to use python to convert days to a date string" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.