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

2 votes181 views1 answer
Show max_allowed_packet mysql
SQL
2 votes169 views2 answers
How to create an empty table from an existing table
SQL
0 vote185 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote186 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
6 votes174 views2 answers
Sql query to get the number of rows in a table
SQL
1 vote173 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote167 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
7 votes238 views2 answers
Drop index oracle
SQL
0 vote167 views1 answer
Oracle remove line breaks
SQL
0 vote168 views1 answer
NLS_NCHAR_CHARACTERSET
SQL