Time值和秒之间相互转换
time_to_sec()、sec_to_time()
select curtime() as '当前时间', sec_to_time(time_to_sec(curtime()) - time_to_sec('00:30:00')) as '30分钟前'
Time值和秒之间相互转换
time_to_sec()、sec_to_time()
select curtime() as '当前时间', sec_to_time(time_to_sec(curtime()) - time_to_sec('00:30:00')) as '30分钟前'
评论已关闭