Avi Schwartz wrote: > Hi, > > I am in the process of evaluating sapdb and what would it take to > convert from SQL Server 7 to sapdb. If you happened to go through a > similar path, I would love to hear any tips on easing the migration. > > One of the problems I am having is loading timestamp fields via the > loader. I generated a fixed column size export from SQL Server but > when I try to load the data, I get an error that the data is > incorrect > for timestamp for every SS dattetime column. I tried to add the > following to the loader script: > > TIMESTAMP 'YYYY-MM-DD HH:MM:SS.NNNNN' > > but I still get the same error. Any idea what may be the problem?
Which date_and_time_format do you use? We know several. http://www.sapdb.org/htmhelp/48/0d8018b4f211d2a97100a0c9449261/frameset.htm You try to use ISO, but did you specify that you want to use that format and not the default internal format? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
