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?

"colin_lyse" <colin_lyse_at_98fgfgs.com> wrote in message news:4370aef3$0$6833$bb4e3ad8_at_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

What is the declared column type for the LOAD_DATE in your example ?

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Nov 2005