Skip to main content

日付to数値

Python​

py
time.mktime(t.timetuple())  # sec  # Python2
py
(t - datetime.datetime.fromtimestamp(0)).total_seconds() # millisec?
py
import time
time.mktime(t.timetuple())  # seconds from epoch (1970-01-01 00:00:00 GMT)  # int

def datetime2epoch(d):
    return time.mktime(datetime.datetime.now().timetuple())

print datetime2epoch(datetime.datetime.now())

PHP​

php
$dt->getTimestamp(); // sec

Ruby​

rb
t.to_f # usec
rb
t.to_i  # int   (sec)
t.to_f  # float (usec)

t.to_i   # seconds from epoch (1970-01-01 00:00:00 GMT)
t.to_f

Excel​

Excel の 1 は「1日」なので、24 x 60 x 60 すると秒数になる