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

3 Answers
8966 Views
I also Faced
E-Mail Answers

Answer Posted / rajan vardawaj

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

Is This Answer Correct ?

17 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I find my mysql username and password?

1000

How many tables we can create in mysql database?

992

What is mysql data directory?

1051

How do I rename a procedure?

921

What is delimiter in mysql stored procedure?

961

Does mysql use t sql?

1024

how to display nth highest salary from a table in a mysql query? : Mysql dba

1117

What is database url for mysql?

1021

How to check server status with 'mysqladmin'?

1228

How do I create a mysql database?

970

What are date and time data types in mysql?

1065

How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1115

What is default password for mysql?

909

What is definer in mysql trigger?

971

How to declare variable in mysql trigger?

1062