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 vote386 views3 answers
Java hide mysql login credentials
SQL
0 vote362 views1 answer
Update having mysql
SQL
3 votes357 views1 answer
Sql is not like
SQL
0 vote317 views1 answer
How to install Firebird
SQL
2 votes362 views1 answer
Datetrunc
SQL
0 vote378 views1 answer
000webhost database values insert
SQL
0 vote349 views1 answer
Datagrip go to line
SQL
4 votes363 views2 answers
Truncate oracle
SQL
4 votes331 views2 answers
Oracle unliock account
SQL
1 vote380 views1 answer
Sql order by timestamp
SQL