DST update on CCM 4.1 in SQL DB

Unanswered Question
Oct 16th, 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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
rob.huffman Sun, 10/18/2009 - 08:03

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

Actions

This Discussion