I think I'll be fine if I remove the milliseconds part. I will give it a try.
Thank you very much for your help.
Avi
On Tuesday, Mar 18, 2003, at 03:19 America/Chicago, Schildberg, Steffen wrote:
Hi Avi,
Avi Schwartz [mailto:[EMAIL PROTECTED] wrote:That's the problem anyway :-( - the converting routine is rather intolerant.
I first tried to use the ISO timestamp format, but when it failed, I assumed it was because the ISO format expect 6 digits for the millisecond part while SQL Server uses only 5 on the export, so I tried to specify my own format map.
So you need either
specify 6 digits for the microsecond part in the mask and change your
data
or in case the microsecond information is not that relevant
you could leave the microseconds completely out of the mask (like TIMESTAMP 'YYYY-MM-DD HH:MM:SS') and specify 5 less positions for your date fields. Doing this the server will add zeroes for the microseconds.
Sorry, I have no other solution right now. It will definitely take some time to adapt the converting routine so I can't provide you with a patch in the next few days.
Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
-- Avi Schwartz [EMAIL PROTECTED]
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
