Get server date mysql

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

Source: stackoverflow.com

Similar codes

0 vote280 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
-1 vote269 views1 answer
Sql add column bit
SQL
0 vote280 views2 answers
Mysql decimal remove trailing zeros
SQL
13 votes303 views3 answers
List all the tables in sql
SQL
3 votes309 views3 answers
Create table in SQL Server
SQL
1 vote310 views1 answer
Db.Database.SqlQuery
SQL
9 votes260 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
9 votes284 views1 answer
Alter table column change data type to text mysql
SQL
16 votes264 views6 answers
Insert sql
SQL
0 vote257 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL