点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
为修复以前的错误,我们将SP 7的数据服务升级到SP 9补丁4,但遇到问题,时间计算中断:
我不明白为什么DS不能只传输先前的时间值? 谁面对过类似的事情?
在将时间转换为本地(函数:utc_to_local())和UTС(函数:local_to_utc())以及计算时差(函数:date_diff())时,也会发生计算错误。
下面是其他字段的计算,计算结果可以在上图中看到:
timestamp = local_to_utc(CreateCopyTime_01.timestamp)
timestamp_2 = local_to_utc(CreateCopyTime_01.timestamp_2,'UTC-00:00')
timestamp_3 = local_to_utc(CreateCopyTime_01.timestamp_2,'UTC + 00:00')
dif_time_himself = date_diff(CreateCopyTime_01.timestamp,CreateCopyTime_01.timestamp,'S')
dif_time2_himself = date_diff(CreateCopyTime_01.timestamp_2,CreateCopyTime_01.timestamp_2,'S')
dif_sys_vs_sys = date_diff(CreateCopyTime_01.timestamp,CreateCopyTime_01.timestamp_2,'S')
dif_sys_vs_utc = date_diff(CreateCopyTime_01.timestamp,local_to_utc(CreateCopyTime_01.timestamp_2),'S')
dif_sys_vs_utc_1 = date_diff(local_to_utc(CreateCopyTime_01.timestamp),CreateCopyTime_01.timestamp_2,'S')
dif_utc_vs_utc = date_diff(local_to_utc(CreateCopyTime_01.timestamp),local_to_utc(CreateCopyTime_01.timestamp_2),'S')
dif_sys_vs_local = date_diff(CreateCopyTime_01.timestamp,utc_to_local(CreateCopyTime_01.timestamp_2),'S')
timestamp_orig = CreateCopyTime_01.timestamp
_______________________________________________________________________
当前系统设置:
操作系统:Windows Server 2012R2
IPS:SAP BusinessObjects BI Platform 4.2 SP 4补丁5(版本:14.2.4.2597)
DS:14.2.9.1822
TimeZone:(UTC)协调世界时
(122.1 kB)
大家好。
我们通过将TZ变量设置为本地时间来解决了这个问题。 (这适用于Unix和Windows操作系统)
一周热门 更多>