![Confused :?](./images/smilies/icon_confused.gif)
Problem with Milliseconds
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 176
- Joined: Wed Nov 15, 2006 5:48 am
We are using the Oracle version 10g
The sql is generated in OCI stage, we have defined the query type :
Generated SELECT clause from column list
More strange is the fact in designer it dosen't appears the millisenconds, only :
TO_CHAR(DTARSL, 'YYYY-MM-DD HH24:MI:SS')
But when i try to do the view data or executed the job, it occcured an error of formated. And when we check the log, it appears the sql :
TO_CHAR(DTARSL, 'YYYY-MM-DD HH24:MI:SS.FF')
Any suggestion ?
merci
Rai ![Cool 8)](./images/smilies/icon_cool.gif)
The sql is generated in OCI stage, we have defined the query type :
Generated SELECT clause from column list
More strange is the fact in designer it dosen't appears the millisenconds, only :
TO_CHAR(DTARSL, 'YYYY-MM-DD HH24:MI:SS')
But when i try to do the view data or executed the job, it occcured an error of formated. And when we check the log, it appears the sql :
TO_CHAR(DTARSL, 'YYYY-MM-DD HH24:MI:SS.FF')
Any suggestion ?
merci
![Cool 8)](./images/smilies/icon_cool.gif)
![Cool 8)](./images/smilies/icon_cool.gif)
Contact your official support provider, that smells like a bug.
ps. When someone asks for an Oracle version, it means all 4 digits. Saying "10g" is way too generic, it should be more like "10.2.0.1" or some such. Some specific versions are more problematic than others.
ps. When someone asks for an Oracle version, it means all 4 digits. Saying "10g" is way too generic, it should be more like "10.2.0.1" or some such. Some specific versions are more problematic than others.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 176
- Joined: Wed Nov 15, 2006 5:48 am
Hi All,RAI ROUSES wrote:the problem was been solved with the inclusion of DS_NO_FF in the desenv file.
DS_NO_FF=1
export DS_NO_FF
Here you have mentioned that the above statements have to be included in desenv file.
Could you please let me know this file path. hope this is not an dsenv file which is available in DSEngine category.
Thanks,