Search
 
SCRIPT & CODE EXAMPLE
 

SQL

check timezone of mysql database

SELECT @@system_time_zone as tz; 
Comment

set database timezone mysql

SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';
Comment

set database timezone mysql

# SET ON /etc/my.cnf

default-time-zone='+00:00'
Comment

PREVIOUS NEXT
Code Example
Sql :: how to check when a stored procedure was last modified in sql server 
Sql :: add primary key constraint in oracle 
Sql :: mysql connection with sqlalchecmy 
Sql :: update column name and datatype in sql 
Sql :: postgresql concatenate multiple rows in group by 
Sql :: stop mysql ubuntu 
Sql :: mysql remove foreign key constraint 
Sql :: postgresql datetrunc too slow 
Sql :: sql server alter column 
Sql :: sql server check port number 
Sql :: file /etc/init.d/mysql not exists 
Sql :: mariadb show tables 
Sql :: get columns number sql 
Sql :: mysql select table names 
Sql :: how to add auto increment primary key 
Sql :: describe table mysql 
Sql :: sql change table name 
Sql :: postgres get next sequence value 
Sql :: sql server if exists update else insert 
Sql :: liquibase update row 
Sql :: postgresql show current database 
Sql :: create procedure with encryption 
Sql :: how to create a variable in mysql 
Sql :: oracle character index 
Sql :: mysql cli connect with password 
Sql :: sql update query 
Sql :: sqlite create index 
Sql :: postgresql create table with boolean column 
Sql :: oracle sequence last_number 
Sql :: view linked servers sql 
ADD CONTENT
Topic
Content
Source link
Name
7+4 =