DST update on CCM 4.1 in SQL DB

ghermant · ‎10-16-2009

Hello,

I have to update manually the DST for Adelaide (Cen. Australia Standard timezone) in the SQL DB as it changed recently.

To do this, can any body tell me what is the format of the "stddate" and "dstdate" field in the DB.

For example, what does the following field means in date?

"stddate" to "0/11/0/1,2:0:0:0"

"dstdate" to "0/3/0/2,2:0:0:0"

Thanks for your help.

Brgds,

Gael

Rob Huffman · ‎10-18-2009

Hi Gael,

Here you go :)

"stddate" to "0/11/0/1,2:0:0:0" 11=November 1= 1st week 0=Sunday

"dstdate" to "0/3/0/2,2:0:0:0" 3=March 2= 2nd week 0=Sunday

Both would be @ 2:00AM

Cheers!

Rob