Axapta / DynamicsAx：UTC datetime转换 [英] Axapta/DynamicsAx: UTC datetime conversion

问题描述

我们正在尝试解释存储在Axapata的TIMEZONESRULESDATA表中的数据。特别是，我们想知道如何存储DST开始/结束时间。到目前为止，我的猜测是：

We are trying to interpret the data stored in Axapata's TIMEZONESRULESDATA table. Particularly, we'd like to figure out how it stores DST begin/end times. So far, my guess is:

TZENUM：外键引用TIMEZONESLIST（时区名称和标识符）

YEAR：0如果规则无限期有效或时间规则生效的一年

BIAS：以UTC为单位的时间偏移量

DBIAS：DST的偏移量（添加到BIAS以获得与UTC的总偏移量）

TZENUM: foreign key referencing TIMEZONESLIST (time zone name and identifier)
YEAR: 0 if rule is valid indefinitely or a year where the timezone rule is in effect
BIAS: offset to UTC time in minutes
DBIAS: offset of DST (added to BIAS to get total offset from UTC)

现在对于我不明白的部分：

Now for the part I don't understand:

DYEAR，DMONTH，DDAYOFWEEK，DDAY，DHOUR，DMINUTE， DSECOND

SYEAR，SMONTH，SDAYOFWEEK，SDAY，SHOUR，SMINUTE，SSECOND

DYEAR,DMONTH,DDAYOFWEEK,DDAY,DHOUR,DMINUTE,DSECOND
SYEAR,SMONTH,SDAYOFWEEK,SDAY,SHOUR,SMINUTE,SSECOND

从D *是开始日期的日期我猜的DST和S *结束。但是，我不明白为什么需要一年和一天的时间。另外，* DAY似乎并不表示月的日期 - 至少它不表示正确的切换DST。它也似乎不符合Axapta自己的DateTimeUtil或Form自动转换日期的日期。

I would guess from the dates that the D* is the start date of DST and S* is end. However, I do not understand why it would need a year and a dayofweek field. Also, *DAY does not seem to indicate the day of month - at least it doesn't indicate the correct one for switching DST. It also doesn't seem to correspond to the dates at which Axapta's own DateTimeUtil or Form autoconversion converts the dates.

有谁知道如何分配这个表？或者在哪里可以查找？

Does anyone know how to interprete this table? Or where I could look it up?

Sören

推荐答案

strong> DDAY 和 SDAY 看起来，就像他们指示一个月的一周，但是后来我们发现了 DDAY - 和 SDAY - 的价值为6,23或28.这些是这些星期的年份，还是被劫持的个人天数？

DDAY and SDAY looked like they indicate the week of month, but then we found DDAY- and SDAY-values of 6, 23 or 28. Are these the weeks of the year, or were the values > 5 hijacked for individual days?

我的理论是这样的：通过 DMONTH = 8和 DDAYOFWEEK = 6，我们有

My theory was this: with DMONTH = 8 and DDAYOFWEEK = 6, we have

• DDAY = 4 ==> 8月第四个星期六


• DDAY = 5 ==> 8月的最后一个星期六


• DDAY = n> 5 ==> 8月（与DDAYOFWEEK可能发生冲突？

• DDAY = 4 ==> 4th saturday in August
• DDAY = 5 ==> last saturday in August
• DDAY = n > 5 ==> n-th of August (possible clash with DDAYOFWEEK?)

那么大于5的 SDAY 和 DDAY ？

这篇关于Axapta / DynamicsAx：UTC datetime转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！