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 vote187 views1 answer
How to format tables in sqlplus
SQL
1 vote200 views1 answer
Sql server reseed single table
SQL
6 votes210 views2 answers
Find mysql version linux
SQL
0 vote204 views1 answer
Sql query to get contact form 7 fields
SQL
20 votes187 views2 answers
Mysql bigint max value
SQL
13 votes179 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
3 votes199 views1 answer
Export postgres database linux
SQL
0 vote206 views1 answer
Get number of tables in database sql
SQL
0 vote232 views1 answer
Check if a column is a primary key in sql server
SQL
-1 vote230 views1 answer
How to Activate the database
SQL