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, 2838🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...