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

3 votes273 views2 answers
Oracle privileges users
SQL
0 vote309 views1 answer
Sql query to select even numbers
SQL
50 votes312 views4 answers
Sql alter type of column
SQL
1 vote288 views1 answer
Oracle columns table
SQL
0 vote275 views1 answer
Oracle tablespace autoextend
SQL
1 vote275 views1 answer
Where not in array sql
SQL
0 vote254 views1 answer
Sql create text column limited values
SQL
2 votes296 views1 answer
Datefromparts mssql
SQL
0 vote271 views1 answer
Mysql exception output
SQL
2 votes249 views1 answer
Query to find table size in oracle 12c
SQL