Field Description TypeTimeZone SQL

[tom]

Everyone,

In CCM 4.x the TypeTimeZone..Table in SQL.

I know it is probably not recommended to make changes here, but I thought it would be interesting to know what these numbers mean in the following fields.

Dstdate

Sdtdate

For example which one the Month, Day, Year and so on?

Dstdate 0/11/0/1,2:0:0:0 and Sdtdate 0/3/0/2,2:0:0:0

Thanks Tom

[rcrumm_2]

This is not all the detail, but 0/11/0/1 is the 1st sunday in November. Likewise the next one is the 2nd Sunday in march.

I believe the 2nd 0 means Sunday. Not sure of the 1st 0. There may also be a time after the comma when it actually changes.

Randall