一、MySql時間戳轉換

select unix_timestamp();  #獲取時間戳格式時間
select FROM_UNIXTIME(1717399499); #將時間戳轉換為普通格式時間

二、Mysql時間相加減結果轉換為秒

方法1：time_to_sec(timediff(endTime, startTime))

SELECTDISTINCT(column1),min(last_modified_time),max(last_modified_time),time_to_sec(timediff(max(last_modified_time), min(last_modified_time))) as time1
FROMtable1
wherecolumn1 = 'aaa';

方法2：timestampdiff(second, startTime, endTime)

SELECTDISTINCT(column1),min(last_modified_time),max(last_modified_time),timestampdiff(second,min(last_modified_time),max(last_modified_time)) as time2
FROMtable1
wherecolumn1 = 'aaa';

方法3：unix_timestamp(endTime) -unix_timestamp(startTime)

SELECTDISTINCT(column1),min(last_modified_time),max(last_modified_time),unix_timestamp(max(last_modified_time)) - unix_timestamp(min(last_modified_time)) as time3
FROMtable1
wherecolumn1 = 'aaa';

三、Mysql時間相加減結果為時分秒

方法：timediff(time1,time2)

SELECTcolumn1,max(last_modified_time),min(last_modified_time),timediff(max(last_modified_time),min(last_modified_time))
FROMtable1
wherecolumn1 = 'aaa';