- 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