DST update on CCM 4.1 in SQL DB

Unanswered Question
Oct 16th, 2009
User Badges:

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Rob Huffman Sun, 10/18/2009 - 08:03
User Badges:
  • Super Red, 40000 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

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