
mysql
JYYYYYYYYYY
这个作者很懒,什么都没留下…
展开
-
mysql时间戳转特定时区的时间
SELECT CONVERT_TZ(FROM_UNIXTIME(1277942400), @@session.time_zone,'+08:00')SELECT CONVERT_TZ(FROM_UNIXTIME(1277942400), @@session.time_zone,'+00:00')原创 2017-09-13 10:26:50 · 5525 阅读 · 0 评论 -
mysql left join写法
SELECT * FROM (select distinct `vOpenID` as vopenid from t_PlayerRegister where 1=1 and 1=1 and dtEventTimei+8*3600<1481817600 AND dtEventTimei>1481212800 and dtRegTimei+8*3600<1481817600 AND dtRe原创 2016-12-15 16:58:35 · 1702 阅读 · 0 评论