Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

DST update on CCM 4.1 in SQL DB

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 REPLY
Hall of Fame Super Red

Re: DST update on CCM 4.1 in SQL DB

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

123
Views
0
Helpful
1
Replies