MySQL Now is one of the Date Functions, which returns the current Date and Time in YYYY-MM-DD HH:MM:SS or YYYYMMDDHHMMSS.uuu format. The basic syntax of the NOW Function is as shown below:
MySQL NOW function Example
The following NOW method query shows you the basic use of this one to get the current DateTime.
SELECT NOW() AS 'Todays date and Time';
The following NOW Function query explains to you what happens when we add value to this.
SELECT NOW() + 5;
SELECT NOW(), NOW() + 5;
From the above screenshot, it added those values to the current datetime. I mean, seconds to the current date and time. Next, it displays the same in YYYYMMDDHHMMSS string format.
In this example, we show you how to use this Now function on columns. Here, we are using a datediff function to find the difference between now and the Hire Date column value.
We use Workbench to write a query against the customer database for this demonstration.
SELECT EmpID, FirstName, LastName, Occupation, YearlyIncome, Sales, HireDate, DATEDIFF(NOW(), HireDate) AS Difference FROM customer;