select curdate(); select current_date(); select date(now());

date funciton

Question Posted / john

Answer Posted / john

select curdate();

select current_date();

select date(now());

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How you will Show unique records.

548

How to enter boolean values in sql statements?

545

How do I run a query in mysql?

489

Is mysql frontend or backend?

484

How much does mysql enterprise cost?

490

Where is the mysql data directory?

499

Tell us something about heap tables?

556

Can you shard mysql?

503

Can we rename database in mysql?

491

What is procedures in mysql?

512

What are slow queries?

484

How do I edit a table in mysql?

497

What is save point in mysql?

519

How many ways to get the current time?

510

How to display nth highest salary from a table in a mysql query?

543