开发者

Insert datastage type timestamp in table SQL Server

I have a datastage project, in which, from oracle tables, I write on SQL Server tables.

The server is on unix machine.

The insert statement, via odbc stage, doesn't work.

Among the fields target to load, there are SQL Server datetime and timestamp.

I do not know how to convert timestamp datastage in those 开发者_开发知识库two formats.

Please, can someone help me!?

Thank you


Datastage "timestamp" is datetime in SQL Server.

SQL Server timestamp is now "rowversion" and is a binary values for the, er, row version

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜