MySQL两个时间字段相减
SELECT class_date_start_time ,class_date_end_time, (UNIX_TIMESTAMP(class_date_end_time)-UNIX_TIMESTAMP(class_date_start_time))/60/60FROM py_class_base
·
SELECT class_date_start_time ,class_date_end_time, (UNIX_TIMESTAMP(class_date_end_time)-UNIX_TIMESTAMP(class_date_start_time))/60/60 FROM py_class_base
-----------------------------------
SELECT start_time ,end_time, (UNIX_TIMESTAMP(end_time)-UNIX_TIMESTAMP(start_time))/60/60 FROM time_time
更多推荐
已为社区贡献3条内容
所有评论(0)