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 MySQL 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.
NOW Example 2
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;