Collections:
Ways to Get the Current Time in MySQL
How Many Ways to Get the Current Time in MySQL?
✍: FYIcenter.com
There are 8 ways to get the current time:
SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql> SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELECT LOCALTIME() FROM DUAL; 2006-07-01 10:07:37 mysql> SELECT LOCALTIMESTAMP() FROM DUAL; 2006-07-01 10:08:08 mysql> SELECT UTC_TIME() FROM DUAL; 14:09:22 mysql> SELECT UTC_TIMESTAMP() FROM DUAL; 2006-07-01 14:09:49
⇒ CREATE, ALTER and DROP Statements in MySQL
⇐ What Is TIMESTAMP Data Type in MySQL
2018-03-13, 1953👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...