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 MySQL 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 current date and time. Next, it is displaying the same in YYYYMMDDHHMMSS string format
MySQL 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.
For this demonstration, we are using Workbench to write a query against the customer database.
SELECT EmpID, FirstName, LastName, Occupation, YearlyIncome, Sales, HireDate, DATEDIFF(NOW(), HireDate) AS Difference FROM customer;