Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why does Oracle 9i show 10/30/05 with a d or s after the time and what does the XXFF time format mean?

Re: Why does Oracle 9i show 10/30/05 with a d or s after the time and what does the XXFF time format mean?

From: Joel Garry <joel-garry_at_home.com>
Date: 7 Nov 2005 13:55:43 -0800
Message-ID: <1131400543.267021.295270@g47g2000cwa.googlegroups.com>


XFF means fractional seconds using the radix character. See http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#sthref448

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements2a.htm#51542

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#sthref154 doesn't really answer the question... but what are your nls_language and nls_territory settings?

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20051105/news_1b5boeing.html
Received on Mon Nov 07 2005 - 15:55:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US