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: 10 Nov 2005 14:47:10 -0600
Message-ID: <4373b164$0$6781$bb4e3ad8@newscene.com>

In article <dkv3an$n0b$1_at_nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>"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

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

found the cause. the load_Date was being passed thru a fucntion and formatted. vendor told us it was direct from table but in reality it was pre-formatted before we saw it Received on Thu Nov 10 2005 - 14:47:10 CST