<\/span><\/h3>\nThis function returns the current date and time, being useful for automatic records of when an insert or update was made to the database.<\/p>\n
SELECT NOW();<\/code><\/pre>\n<\/span>CURDATE()<\/span><\/h3>\nUnlike NOW(), CURDATE() returns only the current date.<\/p>\n
SELECT CURDATE();<\/code><\/pre>\n<\/span>DATEDIFF()<\/span><\/h3>\nIf you need to calculate the difference in days between two dates, DATEDIFF() is your function. For example, to find out how many days have passed since a specific date until today:<\/p>\n
SELECT DATEDIFF(NOW(), '2023-01-01') AS DaysDiff;<\/code><\/pre>\n<\/span>DATE_ADD and DATE_SUB<\/span><\/h3>\nTo add or subtract a time range to a specific date, you can use these functions. For example, to add 10 days to the current date:<\/p>\n
SELECT DATE_ADD(CURDATE(), INTERVAL 10 DAY);<\/code><\/pre>\nOr to subtract 3 months:<\/p>\n
SELECT DATE_SUB(CURDATE(), INTERVAL 3 MONTH);<\/code><\/pre>\n<\/span>DAY(), MONTH(), YEAR()<\/span><\/h3>\nThese functions allow you to extract the day, month, and year of a date, respectively. They are particularly useful for breaking down a date into its components.<\/p>\n
SELECT DAY('2023-08-15'), MONTH('2023-08-15'), YEAR('2023-08-15');<\/code><\/pre>\n<\/span>Advanced DATE Management<\/span><\/h2>\nIn addition to basic operations, there are more advanced techniques for working with dates in MySQL that can be extremely useful in more complex analyzes and generating reports.<\/p>\n