SELECT SUBSTR(username,1,12) username,
       SUBSTR(program,1,15) program, status,
       SUBSTR(To_Char(logon_time, 'day hh24:mi:ss'),1,15) logon_time,
       TRUNC(last_call_et/60) idle_minutes
FROM v$session
WHERE username IS NOT NULL
  AND username  'VIRGIL'
  AND username  'SMUSER'
  And username  'SYSTEM'
  AND TO_CHAR(logon_time, 'day')  TO_CHAR(sysdate,'day');