MySQL Date

How-tos MySQL Date Subtract This article introduces how to subtract dates in MySQL using functions like DATE_SUB and DATEDIFF. Learn effective methods to manipulate date values, calculate differences, and … ↗ How-tos How to Convert String to Date Format in MySQL We will learn about how to convert a string value to DATE type value using STR_TO_DATE(), CONVERT(), and CAST() functions in MySQL. ↗ How-tos How to Get the Current Date in MySQL This tutorial describes the various methods to get the current date from a MySQL host system. ↗ How-tos How to Retrieve Data Within a Date Range in MySQL This tutorial illustrates the method of selecting and retrieving data within a date range in MySQL using comparison operators. ↗ How-tos How to Use the Date_ADD() Function to Add Days and Time in MySQL This tutorial demonstrates the use of DATE_ADD() function to add and minus days and time in MySQL. ↗ How-tos How to Convert From Datetime Type to Date Only in MySQL This tutorial demonstrates the use of DATE(), CAST(), CONVERT(), and DATE_FORMAT() to convert from datetime type to date type in MySQL. ↗ How-tos How to Get Last 30 Days Data in MySQL This article discusses how to get the last 30 days' data records using the SELECT method. We have used now(), data_sub(), curdate(), and between() commands. ↗