techfolks mysql tutorials
Current Timezone of database Current Timezone of mysql Current Timezone of mysql database Current Timezone of mysql server Mysql mysql timezone query

How to Get the Current Timezone of Mysql Database

By running below query you can able to get the Current Timezone of the database server.

select timediff(now(),convert_tz(now(),@@session.time_zone,’+00:00′));

Related Articles

techfolks mysql tutorials
Mysql

How to Add Column to Mysql Table and Auto Increment with Primary Key

viveik

Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY  auto_increment; ALTER TABLE users ADD id […]
Mysql

Decimal(5,3) in Mysql is always 99.999

viveik

The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]
Javascript Mysql PHP

PHP Radio Button Example With Mysql DB

viveik

Simple PHP Radio button enable and disable textarea textbox example in php using Mysql