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

1 vote312 views2 answers
Create a unqie constraint mysql
SQL
0 vote343 views1 answer
How to make sure two tables have same exact data in sql
SQL
3 votes345 views2 answers
How to force truncate a table in mysql
SQL
0 vote349 views1 answer
Datatables server side filter where clause
SQL
0 vote329 views1 answer
Logtash mysql cofiguration file
SQL
3 votes383 views1 answer
Mysql cli connect with password
SQL
3 votes299 views2 answers
Having in mysql
SQL
0 vote316 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote354 views2 answers
Postgres isnull
SQL
-1 vote301 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL