SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME(); SELECT CURRENT

How many ways we can we find the current date using MySQL?

Question Posted / rajan vardawaj

Answer Posted / rajan vardawaj

SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME();
SELECT CURRENT_TIME();

Is This Answer Correct ?

17 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I copy a table in mysql workbench?

884

I want to find out all databases starting with ‘test’, I have access to?

1155

How to check server status with 'mysqladmin'?

1168

How can I create table in mysql?

1021

How do I truncate all tables in mysql?

985

Give string types available for column?

988

What is mysql server used for?

958

How do you backup a database in mysql?

1067

Write a query to retrieve a hundred books starting from 20th.

1512

What are the difference between mongodb and mysql?

1353

What are the two types of queries?

966

How do I find mysql location?

972

How can I see all mysql databases?

891

How do I restore a database in mysql workbench?

1005

How can we find out which auto increment was assigned on Last insert?

1098