开发者

Insert datastage type timestamp in table SQL Server

开发者 https://www.devze.com 2023-01-31 23:33 出处:网络
I have a datastage project, in which, from oracle tables, I write on SQL Server tables. The server is on unix machine.

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

精彩评论

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