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 vote219 views1 answer
Reindex mssql table
SQL
0 vote224 views1 answer
Sql today at midnight
SQL
1 vote200 views1 answer
Give a column name to values generated from case statement in sql
SQL
1 vote220 views1 answer
Oracle compile schema
SQL
10 votes198 views1 answer
Query to find object dependencies in oracle
SQL
0 vote181 views1 answer
Mysql group rows with same value
SQL
1 vote199 views1 answer
Oracle apex run 404
SQL
0 vote230 views1 answer
Mysql relationships between tables
SQL
4 votes265 views2 answers
DB::transaction
SQL
0 vote197 views1 answer
Change database name psql 8
SQL