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?

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?

From: colin_lyse <colin_lyse_at_98fgfgs.com>
Date: 8 Nov 2005 08:00:02 -0600
Message-ID: <4370aef3$0$6833$bb4e3ad8@newscene.com>

In article <1131400543.267021.295270_at_g47g2000cwa.googlegroups.com>, "Joel Garry" <joel-garry_at_home.com> wrote:
>XFF means fractional seconds using the radix character. See
>http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_element
>s004.htm#sthref448
>
>http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_element
>s2a.htm#51542
>
>http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_element
>s001.htm#sthref154
>doesn't really answer the question... but what are your nls_language
>and nls_territory settings?
>
>jg

NLS_TERRITORY AMERICA

NLS_DATE_FORMAT MM/DD/YYYY 
NLS_DATE_LANGUAGE AMERICAN 
NLS_SORT BINARY 
NLS_TIME_FORMAT HH.MI.SSXFF AM 
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM 
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR 
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR 

the main issue is with the following
ESP_NAME        LOAD_DATE       LOAD_VAL
1214            2004-10-31 01:00d       774.401
1214            2004-10-31 01:00s       754.4165
1214            2004-10-31 02:00s       754.4165
1214            2004-10-31 03:00s       744.3678
1214            2004-10-31 04:00s       738.4426

note that Oracle is putting an 's' and a 'd' after the date. other apps are seeing that and getting confused. and also how do we parse this info, e don't want to be converting to char and back Received on Tue Nov 08 2005 - 08:00:02 CST