Msyql 不规则、任意日期转换标准时间

最新推荐文章于 2023-05-30 14:17:55 发布

ghostyusheng

最新推荐文章于 2023-05-30 14:17:55 发布

阅读量724

点赞数

分类专栏：解决方案文章标签： mysql不规则时间 mysql任意时间转换标准时间

本文链接：https://blog.csdn.net/ghostyusheng/article/details/52224550

版权

解决方案专栏收录该内容

121 篇文章 1 订阅

订阅专栏

select DATE_FORMAT(STR_TO_DATE(end_date, '%d/%m/%Y'), '%Y-%m-%d') from app_coupon_api

//------------------------------------------------------------------------------------------------------------------------------------------

select count(*) from
(
select * from app_coupon_api where website = 'Fancyladies.com' and status = 'public' and UNIX_TIMESTAMP(STR_TO_DATE(left(end_date,10), '%m/%d/%Y')) > UNIX_TIMESTAMP(now())
union
select * from app_coupon_api where website = 'Fancyladies.com' and status = 'public' and UNIX_TIMESTAMP(STR_TO_DATE(left(end_date,10), '%m/%d/%Y')) = 0
union
select * from app_coupon_api where website = 'Fancyladies.com' and status = 'public' and end_date is null
)t