Hi Avi, Avi Schwartz [mailto:[EMAIL PROTECTED] wrote: > > 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. > That's the problem anyway :-( - the converting routine is rather intolerant. 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
