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 vote260 views1 answer
Nullif postgresql
SQL
0 vote219 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote198 views1 answer
Postgresql update auto_increment value
SQL
0 vote235 views1 answer
Create a plsql object
SQL
0 vote225 views1 answer
Contraint default SQL
SQL
1 vote218 views1 answer
Postgres cast as currency format
SQL
0 vote230 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote226 views2 answers
Getting customers with no orders sql
SQL
6 votes223 views2 answers
Sql display max value
SQL
1 vote232 views2 answers
Mysql update LAST_INSERT_ID()
SQL