함수 time diff()

time_diff

time_difference

1 Excel

• A1 = 2000-01-01 00:00:00
• A2 = 2000-01-02 12:34:56

=(A2-A1)*86400
// 131696

2 PHP

$dt1 = '2000-01-01 00:00:00';
$dt2 = '2000-01-02 12:34:56';
echo date('U',strtotime($dt2))-date('U',strtotime($dt1));
# 131696

function time_diff($dt1, $dt2) {
  return date('U',strtotime($dt2))-date('U',strtotime($dt1));
}
echo time_diff('2000-01-01 00:00:00', '2000-01-02 12:34:56');
# 131696
echo time_diff('2000-01-02 12:34:56', '2000-01-01 00:00:00');
# -131696

3 Python

from datetime import datetime
dt1 = '2000-01-01 00:00:00'
dt2 = '2000-01-02 12:34:56'
delta = datetime.strptime(dt2, '%Y-%m-%d %H:%M:%S') - datetime.strptime(dt1, '%Y-%m-%d %H:%M:%S')
print( delta.days*86400 + delta.seconds )

from datetime import datetime
def time_diff(dt1, dt2):
    delta = datetime.strptime(dt2, '%Y-%m-%d %H:%M:%S') - datetime.strptime(dt1, '%Y-%m-%d %H:%M:%S')
    return delta.days * 86400 + delta.seconds
dt1 = '2000-01-01 00:00:00'
dt2 = '2000-01-02 12:34:56'
print( time_diff(dt1, dt2) )

4 같이 보기

• 함수 date_diff()
• 함수 datetime2unixtime()