Learn MySQL Tutorial
In MySQL, the SYSDATE function is used to retrieve the current date and time from the system. This function returns a DATETIME value representing the current date and time in the system’s time zone. It is important to note that the time zone used by SYSDATE is the time zone set on the MySQL server. […]
The MySQL SECOND function is a date and time function that is used to extract the seconds component from a given time expression. It is particularly useful when you need to retrieve or manipulate specific parts of a time value. The basic syntax of the SECOND function is as follows: Syntax SECOND(time_expression) Here, time_expression is […]
In MySQL, the MONTH function is used to extract the month from a date. It is particularly useful when you have a date column in your database, and you want to retrieve only the month part of it. Syntax The syntax for the MONTH function is quite straightforward: MONTH(date) Here, date is the input date […]
The MINUTE function in MySQL extracts the minute component from a given time or datetime value. It returns an integer value ranging from 0 to 59, corresponding to the minutes in the specified time. This function is commonly used in conjunction with other date and time functions to perform various data analysis and manipulation tasks. […]
The MySQL LAST_DAY function is a date function that returns the last day of the month for a given date or date expression. It is particularly useful when you want to find the end date of a specific month. Syntax The syntax for the LAST_DAY function is as follows: LAST_DAY(date) Here, “date” is the input […]
The HOUR function in MySQL is used to extract the hour from a given time or datetime expression. It returns an integer value representing the hour of the specified time. Syntax Here’s the basic syntax of the HOUR function: HOUR(time) time: This is the time or datetime value from which you want to extract the […]
© MySQL Tutorial 2025.