함수 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));

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

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 같이 보기[ | ]