SELECT
TO_CHAR(START_TIME,'DD-MON-YYYY') Login_Time,
COUNT(*) cnt
FROM fnd_logins
WHERE
START_TIME >
( SELECT TO_DATE('25-AUG-2010 00:00:00','DD-MON-YYYY HH24:MI:SS')
FROM dual
)
AND login_type IS NOT NULL
AND END_TIME IS NULL
GROUP BY TO_CHAR(START_TIME,'DD-MON-YYYY');
No comments:
Post a Comment