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 vote312 views1 answer
How to insert same table data using mysql query
SQL
25 votes373 views6 answers
Import database mysql command line
SQL
0 vote307 views2 answers
Sql update from two different database
SQL
0 vote340 views1 answer
How to select only id where is not in column mysql
SQL
11 votes337 views5 answers
How to install sqlite3 python
SQL
0 vote357 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
4 votes342 views1 answer
T-sql get duplicate rows
SQL
4 votes349 views2 answers
Sql offset
SQL
44 votes390 views6 answers
Rename command in sql
SQL
5 votes354 views2 answers
Get number of columns sql
SQL