JIYIK CN >

MySQL has various operations that facilitate the use and maintenance of relational databases. It has various built-in functions that help in the use of this tool.

These functions simplify manual work by taking parameters and providing results to specialized functions.

These functions include various operations on strings, numbers, dates, and advanced functions in MySQL. Examples of such functions include concat , reverse , position , min , max , and truncate .

Subtracting dates in MySQL

MySQL provides functions to change and manage date and time as required in your tools. Following are some of the date time utility functions.

1. The Date function extracts data in DDMMYYYY format from a DateTime string.
2. The DayOfMonth function returns the period of a complete date after completing the internal extraction process.
3. The Date_Add function returns the date and time interval added from a given date.
4. The Date_Sub function returns the date and time interval subtracted from a supplied date.

Query and execute MySQL statements:

select * from student where DOB between DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW();

1. The above query selects all birth dates between the current date and the last 30 days. The selection is preceded by *an asterisk, which means all records from the filtered list.
2. The from keyword specifies the user provided table name from which we apply the condition or filter.
3. The usage of where keyword acts as a conditional operator. Here all the conditions are specified to show a particular result.
4. After filtering out the results between queries, the results are captured from the Student table.
5. The between operator returns the selected values ​​within a given range, which can be integers, strings, or part of a date. The above query returns inclusive date range, which means the first and last value are part of the date range.
6. The now function returns a date and time in the format YYYY-MM-DD HH-MM-SS.
7. The Date_Sub function takes two arguments, the first of which represents the value to be changed. The second argument is the date or time value that should be subtracted.

   These values ​​can be minutes, seconds, hours, days, etc.