mysql 时间戳与日期格式的相互转换

1、UNIX时间戳转换为日期用函数： FROM_UNIXTIME()

 select FROM_UNIXTIME(1156219870);  

输出：2006-08-22 12:11:10

2、日期转换为UNIX时间戳用函数： UNIX_TIMESTAMP()

Select UNIX_TIMESTAMP('2006-11-04 12:23:00');  

输出：1162614180  

 SELECT b.coupon_code,b.coupon_use_status,a.coupon_id,a.coupon_use_end_date from xiangxia a LEFT JOIN xiangxia_use b on a.coupon_id = b.coupon_id WHERE UNIX_TIMESTAMP(a.coupon_use_end_date)+86399 < UNIX_TIMESTAMP(now()) and b.coupon_code != '' and(b.coupon_use_status !=3 and b.coupon_use_status != 4);