How can we get current date and time in MySQL?

We can use following query in MySQL to get the current date:

SELECT CURRENT_DATE();

We can use following query in MySQL to get the current time as well as date:

SELECT NOW();

Read the full book at www.amazon.com
Posted in MySQL, MySQL Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *

*