1'#--------------------FN_DYNVARS_022_01-------------------------#'
2## Setting variable's value to 0 ##
3SET @@session.default_week_format = 0;
4SELECT @@session.default_week_format;
5@@session.default_week_format
60
7SELECT WEEK('2008-01-20');
8WEEK('2008-01-20')
93
10## Setting variable's value to 1 ##
11SET @@session.default_week_format = 1;
12SELECT @@session.default_week_format;
13@@session.default_week_format
141
15SELECT WEEK('2008-01-20');
16WEEK('2008-01-20')
173
18## Setting variable's value to 2 ##
19SET @@session.default_week_format = 2;
20SELECT @@session.default_week_format;
21@@session.default_week_format
222
23SELECT WEEK('2008-01-20');
24WEEK('2008-01-20')
253
26## Setting variable's value to 3 ##
27SET @@session.default_week_format = 3;
28SELECT @@session.default_week_format;
29@@session.default_week_format
303
31SELECT WEEK('2008-01-20');
32WEEK('2008-01-20')
333
34## Setting variable's value to 4 ##
35SET @@session.default_week_format = 4;
36SELECT @@session.default_week_format;
37@@session.default_week_format
384
39SELECT WEEK('2008-01-20');
40WEEK('2008-01-20')
414
42## Setting variable's value to 5 ##
43SET @@session.default_week_format = 5;
44SELECT @@session.default_week_format;
45@@session.default_week_format
465
47SELECT WEEK('2008-01-20');
48WEEK('2008-01-20')
492
50## Setting variable's value to 6 ##
51SET @@session.default_week_format = 6;
52SELECT @@session.default_week_format;
53@@session.default_week_format
546
55SELECT WEEK('2008-01-20');
56WEEK('2008-01-20')
574
58## Setting variable's value to 7 ##
59SET @@session.default_week_format = 7;
60SELECT @@session.default_week_format;
61@@session.default_week_format
627
63SELECT WEEK('2008-01-20');
64WEEK('2008-01-20')
652
66