Knowledge Walls
John Peter
Pune, Maharashtra, India
How to get Current TimeZone Date and UTC or GMT date time in Mysql
2538 Views
Example
SELECT CURRENT_TIMESTAMP;
SELECT UTC_TIMESTAMP;
Output 
How it works 
CURRENT_TIMESTAMP returns Current TimeZone timestamp of server.
UTC_TIMESTAMP returns UTC or GMT date time.
Previous Topics
Previous lessons of current book.
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details