如何在DS SP9补丁4中设置时区?

2020-09-21 19:20发布

         点击此处--->   EasySAP.com群内免费提供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)

         点击此处--->   EasySAP.com群内免费提供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)
付费偷看设置
发送
1条回答
灬番茄
1楼-- · 2020-09-21 19:26

大家好。

我们通过将TZ变量设置为本地时间来解决了这个问题。 (这适用于Unix和Windows操作系统)

一周热门 更多>