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 vote370 views1 answer
Restart serial number for postgres
SQL
0 vote318 views1 answer
For row in sql database python loop
SQL
5 votes315 views2 answers
Add days in oracle sql
SQL
0 vote294 views1 answer
How to update date value in sql
SQL
-1 vote243 views1 answer
Plsql while
SQL
0 vote284 views1 answer
Split string by comma in sql server
SQL
1 vote333 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote272 views1 answer
Sqlite update where exists
SQL
1 vote301 views1 answer
Sql check roles
SQL
1 vote296 views1 answer
Sql server read uncommitted
SQL