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