#!/usr/bin/python
# -*- coding: UTF-8 -*-
"""
@author: Roc-xb
"""
 
from datetime import datetime
from xlrd import xldate_as_tuple
 
'''
函數功能：將天數格式化為日期字符串
天數：表示從1990-01-01到某天的天數
'''
def days_to_date_str(days):
    real_date = datetime(*xldate_as_tuple(days, 0)).strftime('%Y-%m-%d')
    print(real_date)
    return real_date
 
if __name__ == '__main__':
    days = 44570
    days_to_date_str(days)

    a = "2013-10-10 23:40:00"
    # 將其轉換為時間數組
    import time
    timeArray = time.strptime(a, "%Y-%m-%d %H:%M:%S")
    # 轉換為時間戳
    timeStamp = int(time.mktime(timeArray))
    timeStamp == 1381419600