1
'#--------------------FN_DYNVARS_022_01-------------------------#'
2
## Setting variable's value to 0 ##
3
SET @@session.default_week_format = 0;
4
SELECT @@session.default_week_format;
5
@@session.default_week_format
7
SELECT WEEK('2008-01-20');
10
## Setting variable's value to 1 ##
11
SET @@session.default_week_format = 1;
12
SELECT @@session.default_week_format;
13
@@session.default_week_format
15
SELECT WEEK('2008-01-20');
18
## Setting variable's value to 2 ##
19
SET @@session.default_week_format = 2;
20
SELECT @@session.default_week_format;
21
@@session.default_week_format
23
SELECT WEEK('2008-01-20');
26
## Setting variable's value to 3 ##
27
SET @@session.default_week_format = 3;
28
SELECT @@session.default_week_format;
29
@@session.default_week_format
31
SELECT WEEK('2008-01-20');
34
## Setting variable's value to 4 ##
35
SET @@session.default_week_format = 4;
36
SELECT @@session.default_week_format;
37
@@session.default_week_format
39
SELECT WEEK('2008-01-20');
42
## Setting variable's value to 5 ##
43
SET @@session.default_week_format = 5;
44
SELECT @@session.default_week_format;
45
@@session.default_week_format
47
SELECT WEEK('2008-01-20');
50
## Setting variable's value to 6 ##
51
SET @@session.default_week_format = 6;
52
SELECT @@session.default_week_format;
53
@@session.default_week_format
55
SELECT WEEK('2008-01-20');
58
## Setting variable's value to 7 ##
59
SET @@session.default_week_format = 7;
60
SELECT @@session.default_week_format;
61
@@session.default_week_format
63
SELECT WEEK('2008-01-20');