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 vote118 views1 answer
Stop mysql server mac
SQL
0 vote136 views1 answer
Sql include rows with 0 values
SQL
0 vote141 views1 answer
Test database for sql
SQL
0 vote143 views1 answer
Select new table sql
SQL
0 vote144 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote142 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote123 views1 answer
Datetime postgres typeorm
SQL
0 vote141 views1 answer
Sql query for login with email or username
SQL
1 vote134 views1 answer
Mysql decimal allow negative values?
SQL
1 vote128 views1 answer
Update from select join
SQL