Home » SQL & PL/SQL » SQL & PL/SQL » to check user logged in to apps
icon8.gif  to check user logged in to apps [message #249733] Thu, 05 July 2007 12:40
vamcs
Messages: 20
Registered: June 2007
Location: somerset
Junior Member

Please write a query to identify user’s that have logged into the apps on Sat. and Sun. Beijing time. Time zone = HKT, which is PDT+15. Here’s my attempt at the query, but ‘HKT’ is not registered as a time zone. Please can any one see what you can do.
select

DISTINCT l.START_TIME START_PDT, TO_CHAR(l.START_TIME,'DAY') START_DAY_PDT

,NEW_TIME(TO_DATE(l.START_TIME,'DD-MON-YY HH24:MI:SS'),'PST','GMT') START_GMT

,l.END_TIME,u.USER_NAME,u.*

from fnd_logins L

,fnd_user u

where l.USER_ID=u.USER_ID

and login_type='FORM'

and l.START_TIME>='01-JUN-07'

AND USER_NAME NOT IN ('SYSADMIN','GUEST')

AND (TO_CHAR(l.START_TIME,'DAY')LIKE 'SATURDAY%' OR TO_CHAR(l.START_TIME,'DAY')LIKE '%SUNDAY%')



Previous Topic: delay calculation
Next Topic: How To Log a PL/SQL Transaction...
Goto Forum:
  


Current Time: Wed Dec 07 10:31:07 CST 2016

Total time taken to generate the page: 0.07860 seconds