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 vote316 views1 answer
Mysql zerofill
SQL
0 vote249 views1 answer
Count char in java
SQL
0 vote346 views1 answer
Postgres rename database
SQL
22 votes296 views4 answers
Mysql reset auto increment id
SQL
1 vote267 views2 answers
Into sql
SQL
0 vote273 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
13 votes282 views2 answers
Oracle inner join
SQL
0 vote343 views1 answer
Eliminate zero from integer mysql
SQL
0 vote301 views1 answer
Postgres week number
SQL
0 vote299 views1 answer
Less than date query sqlachemy
SQL