Shulou(Shulou.com)06/01 Report--

1. Define the variable declare @ startTime varchar (255)-2. Set the variable set @ startTime = convert (VARCHAR (10), dateadd (day,-1,getdate () +'%'--you can also specify the date to be queried here-- set @ startTime = '2017-04-05% select REPLACE-display the specified date PRINT (@ startTime) select REPLACE (@ startTime,'%','') as date, active users of the day, and new users from (--3.) Query current-day active users select '01' as id,count (1) as current-day active users from (select DISTINCT usId from loginLog t where CONVERT (varchar, t.addTime, 25) like @ startTime) as a) as a2 mai-4. Query new users on the same day (select '01' as id,count (1) as) from userT t where CONVERT (varchar (100), t.addTime, 25) like @ startTime) bwhere a2.id = b.id

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.