Edit File: default_week_format_func.result
'#--------------------FN_DYNVARS_022_01-------------------------#' ## Setting variable's value to 0 ## SET @@session.default_week_format = 0; SELECT @@session.default_week_format; @@session.default_week_format 0 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 3 ## Setting variable's value to 1 ## SET @@session.default_week_format = 1; SELECT @@session.default_week_format; @@session.default_week_format 1 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 3 ## Setting variable's value to 2 ## SET @@session.default_week_format = 2; SELECT @@session.default_week_format; @@session.default_week_format 2 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 3 ## Setting variable's value to 3 ## SET @@session.default_week_format = 3; SELECT @@session.default_week_format; @@session.default_week_format 3 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 3 ## Setting variable's value to 4 ## SET @@session.default_week_format = 4; SELECT @@session.default_week_format; @@session.default_week_format 4 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 4 ## Setting variable's value to 5 ## SET @@session.default_week_format = 5; SELECT @@session.default_week_format; @@session.default_week_format 5 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 2 ## Setting variable's value to 6 ## SET @@session.default_week_format = 6; SELECT @@session.default_week_format; @@session.default_week_format 6 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 4 ## Setting variable's value to 7 ## SET @@session.default_week_format = 7; SELECT @@session.default_week_format; @@session.default_week_format 7 SELECT WEEK('2008-01-20'); WEEK('2008-01-20') 2
Back to File Manager