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 vote132 views1 answer
Datatables server side filter where clause
SQL
0 vote122 views2 answers
Oracle create chain rule
SQL
0 vote115 views1 answer
Dump only schema
SQL
0 vote128 views1 answer
Mysql grant grant option
SQL
0 vote114 views1 answer
Truncate table sql server foreign key
SQL
0 vote122 views1 answer
Select a row include list of array with join table SQL
SQL
1 vote112 views2 answers
Sql example query
SQL
2 votes139 views1 answer
Power query concatenate
SQL
39 votes229 views5 answers
Sql drop column
SQL
3 votes133 views1 answer
Insert into table from another table mysql
SQL