日期:2014-05-17 浏览次数:20828 次
select userName, to_date(to_char(LOGINTIME, 'yyyy'), 'yyyy') period, count(*) from EOSADMINLOGINTRACE group by userName, to_date(to_char(LOGINTIME, 'yyyy'), 'yyyy') order by to_date(to_char(LOGINTIME, 'yyyy'), 'yyyy');
select userName, to_date(to_char(LOGINTIME, 'yyyy-MM'), 'yyyy-MM') period, count(*) from EOSADMINLOGINTRACE group by userName, to_date(to_char(LOGINTIME, 'yyyy-MM'), 'yyyy-MM') order by to_date(to_char(LOGINTIME, 'yyyy-MM'), 'yyyy-MM');
select userName, to_date(to_char(LOGINTIME, 'yyyy-MM-dd'), 'yyyy-MM-dd') period, count(*) from EOSADMINLOGINTRACE group by userName, to_date(to_char(LOGINTIME, 'yyyy-MM-dd'), 'yyyy-MM-dd') order by to_date(to_char(LOGINTIME, 'yyyy-MM-dd'), 'yyyy-MM-dd');