DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Help with Time value in Date colum

  1. #1
    Join Date
    Nov 2000
    Location
    Potomac, Maryland
    Posts
    85

    Question

    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
    ...

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    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.

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    MM means month
    MI means minute

    :)

    - Chris

  4. #4
    Join Date
    Nov 2000
    Location
    Potomac, Maryland
    Posts
    85
    pwoneil and Chris,

    Thank you very much for the help !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width