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, 2709🔥, 0💬
Popular Posts:
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...