함수 time_diff()


time_diff
time_difference

1 Excel[ | ]

  • A1 = 2000-01-01 00:00:00
  • A2 = 2000-01-02 12:34:56
PHP
Copy
=(A2-A1)*86400
// 131696

2 PHP[ | ]

PHP
Copy
$dt1 = '2000-01-01 00:00:00';
$dt2 = '2000-01-02 12:34:56';
echo date('U',strtotime($dt2))-date('U',strtotime($dt1));
Loading
PHP
Copy
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') );
Loading

3 Python[ | ]

Python
Copy
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 )
Loading
Python
Copy
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) )
Loading

4 같이 보기[ | ]