Leslie,
Hint #1: Try 'mm/dd/yy hh:mi:ss am' for your format string.
Hint #2: 'mm' is month, 'mi' is minutes.
Hint #3: As September is the 9th month, I think your output makes
sense. ;-)
(I remember making this mistake, oh, probably more than 10 years ago, on
version 6. Some things never chan
Your format is asking for the month instead of the minutes
>
> Hi all,
>
> I did a select sysdate from dual, and got 04:09:39 pm,
> but my machine system time is 4:47pm, which is right.
>
> SQL> select to_char(sysdate,'mm/dd/yy hh:mm:ss am')
^^
shoul
Hi all,
I did a select sysdate from dual, and got 04:09:39 pm,
but my machine system time is 4:47pm, which is right.
SQL> select to_char(sysdate,'mm/dd/yy hh:mm:ss am')
from dual;
TO_CHAR(SYSDATE,'MM/
09/12/02 04:09:39 pm
How did Oracle get the time? What needs to be set
