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 vote190 views1 answer
Sql delete from with relation
SQL
0 vote176 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote187 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote195 views1 answer
Bidirectional outer join sql
SQL
0 vote197 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote184 views1 answer
Mariadb used space
SQL
8 votes212 views3 answers
Find table for column name in sql
SQL
0 vote173 views2 answers
Create fulltext index mysql
SQL
1 vote189 views1 answer
Table valued functions in sql
SQL
0 vote200 views2 answers
Wordpress change url after migration mysql query
SQL