How to calculate the difference between two dates, in the format YYYY-MM-DD hh: mm: ss
and to get the result in seconds or milliseconds?
相关问题
- SQL join to get the cartesian product of 2 columns
- sql execution latency when assign to a variable
- Difference between Types.INTEGER and Types.NULL in
- php PDO::FETCH_ASSOC doesnt detect select after ba
- sqlyog export query result as csv
Why not just
Select Sum(Date1 - Date2) from table
date1 and date2 are datetime