muysql bigint转换为date, 字段值比较

来源:互联网 发布:java poi 导出excel 编辑:程序博客网 时间:2024/06/10 08:53


SELECT a.phone, from_unixtime(a.ts/1000) ,ts > 1356969601000 AND ts < 1364745599000 FROM giftcard_distinct_copy a where a.phone in(


SELECT phone FROM giftcard_s


)
ORDER BY a.phone asc
原创粉丝点击