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 change! ;-)) Hope that helps, -Mark On Thu, 2002-09-12 at 19:53, Leslie Lu wrote: > 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 in > order to get the correct time? > > Thank you in advance! > > Leslie > > __________________________________________________ > Do you Yahoo!? > Yahoo! News - Today's headlines > http://news.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] "It is not enough to have a good mind. The main thing is to use it well." -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
