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 vote301 views1 answer
Alter table fulltext
SQL
8 votes297 views1 answer
Mysql restore database
SQL
25 votes309 views6 answers
Sql update query
SQL
3 votes316 views1 answer
Oracle sleep
SQL
0 vote290 views1 answer
Sql select column names starting with
SQL
1 vote280 views1 answer
Mysql select utc time in eastern time
SQL
1 vote310 views1 answer
Select tables with name like mysql
SQL
0 vote318 views1 answer
Radius search with point data in mysql
SQL
13 votes300 views2 answers
Mysql order by multiple columns
SQL
1 vote304 views1 answer
Insert column after column mysql
SQL