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 php tutorials logo
General Mysql PHP

10 Mistakes Which PHP MySQL Developers Make

viveik

1. Using MyISAM rather than InnoDB MySQL has a number of database engines, but you’re most likely to encounter MyISAM and InnoDB. MyISAM is used by default. However, unless you’re creating a very simple or experimental database, it’s almost certainly the wrong choice! MyISAM doesn’t support foreign key constraints or transactions, which are essential for […]

PHP Mysql Visitor Counter Script
Mysql PHP PHP Scripts Sample Programs

PHP Mysql Visitor Counter Script

viveik

If you want to add a counter to a web page or a website then use the below simple PHP Counter Script using MySql. It is very easy to implement it and it counts whenever a page is being refreshed and the script won’t reduce page speed, unlike page counter scripts. PHP Visitor Counter Script […]
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