开发者

setting max date value to oracle 10g from sql2000+n

开发者 https://www.devze.com 2023-01-21 06:23 出处:网络
Hi I have this update statement UPDATE OPENQUERY(linkedServerToOracle ,\"SELECTT$TDAT FROM BAAN.TTDSLS031010 WHERE T$CUNO=\'003098\' AND T$CPGS=\' 4AN00\'\")

Hi I have this update statement

UPDATE OPENQUERY(linkedServerToOracle ,"SELECT   T$TDAT FROM BAAN.TTDSLS031010 WHERE T$CUNO='003098' AND T$CPGS=' 4AN00'") 
SET T$TDAT=CONVERT(varchar, '4712-01-01 00:00', 121)

and the current setting in linkedServerToOracle (10g) is supposed to take the value '4712-01-01 0开发者_开发知识库0:00' as pseudo infinite date time i.e Applications supposed to render this value blank (eg BaaN 4c ).. but it does not do that when I update the column in question through linkedServer.. Any help is appriciated.. Thanks


Apparently setting a date to Julian 0 seconds as following do the trick..

Update baan.ttipcs530070 set t$pddt=to_date('1 0','J SSSSS')
0

精彩评论

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