-
Hello,
When I run the following query, I was expecting to see the UserName , Date and Time the user logged on.
It appears that everything is working ok except for the minute value. It's always returning 12 no matter when a user logged on. Is there something I need to enable somewhere for this to work correctely or what I'm am doing wrong? Please help.
Robel
Query:
SELECT
RPAD(OSUSER,6,' ') "User",
TO_CHAR(LOGON_TIME,'MM/DD/YYYY HH24:MM:SS') "Logon Date and Time"
from V$SESSION
ORDER BY
"Logon Date and Time"
Result:
User Logon Date and Time
------ -------------------
SYSTEM 11/28/2000 08:11:49
SYSTEM 11/28/2000 08:11:50
SYSTEM 11/28/2000 08:11:50
SYSTEM 11/28/2000 08:11:51
SYSTEM 11/28/2000 08:11:52
SYSTEM 11/28/2000 08:11:52
LPSRVR 12/04/2000 09:12:00
ADJH1 12/07/2000 07:12:01
A5CJ1 12/07/2000 07:12:02
A6CB1 12/07/2000 08:12:51
ABRH1 12/07/2000 08:12:59
SC3AR1 12/07/2000 09:12:00
a7rb1 12/07/2000 09:12:00
Z3DW1 12/07/2000 09:12:01
A8SW1 12/07/2000 10:12:16
G3LH1 12/07/2000 10:12:21
SC3SB1 12/07/2000 10:12:35
a5tg1 12/07/2000 10:12:39
A5JN1 12/07/2000 10:12:50
S3DF1 12/07/2000 11:12:01
KGKB1 12/07/2000 12:12:18
J3PS1 12/07/2000 12:12:29
KGKB1 12/07/2000 12:12:42
K3SZ1 12/07/2000 12:12:44
T3CF1 12/07/2000 12:12:46
...
-
It's not always returning 12, notice the first few are returning 11. Which just so happens it's the month :) MM is month, minutes are MI.
-
MM means month
MI means minute
:)
- Chris
-
pwoneil and Chris,
Thank you very much for the help !
