함수 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));
}
$dt1 = '2000-01-02 12:34:56';
$dt2 = '2000-01-01 00:00:00';
echo time_diff($dt1, $dt2);
// -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 )
# 131696

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) )
# 131696

4 같이 보기