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 vote155 views1 answer
Get a list of tables and the primary key
SQL
17 votes150 views3 answers
Cast in sql server
SQL
2 votes153 views2 answers
Select list is not in group by clause
SQL
0 vote158 views1 answer
Big table in mysql
SQL
2 votes162 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote140 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
4 votes142 views1 answer
Add constraint fk
SQL
1 vote159 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
0 vote169 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote142 views1 answer
Csv to sqlite python
SQL