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 votes208 views1 answer
Mysql set field unique
SQL
0 vote217 views2 answers
Sql update multiple tables
SQL
0 vote226 views1 answer
000webhost database values insert
SQL
0 vote254 views1 answer
For select oracle
SQL
22 votes240 views3 answers
How to join three tables in sql using joins
SQL
0 vote243 views1 answer
Sql query to find percentage of null values in a table
SQL
1 vote213 views1 answer
Altering the column name in MySQL to have a default value
SQL
5 votes241 views1 answer
Oracle drop index if exists
SQL
1 vote204 views1 answer
Create index concurrently postgres
SQL
0 vote247 views1 answer
Sql date with year
SQL