Learn MySQL Tutorial
The MySQL CHAR_LENGTH function is used to determine the number of characters in a given string. It is a character set-aware function, which means it takes into account the character set used for the string. The function returns the length of the string in characters, not bytes. Syntax Here’s the basic syntax of the CHAR_LENGTH […]
The MySQL YEAR function is a date and time function used to extract the year from a given date. It is particularly useful when you want to retrieve only the year portion of a date value stored in a MySQL database. Syntax The syntax for the YEAR function is quite straightforward: YEAR(date) Here, the date […]
The MySQL WEEKDAY function is used to determine the day of the week for a given date. It returns an integer value representing the day of the week, where Monday is assigned the value 0 and Sunday is assigned the value 6. This function can be particularly useful in scenarios where you need to perform […]
The WEEK function in MySQL is a date and time function that is used to extract the week number from a given date. It is particularly useful when working with temporal data and analyzing trends over weeks. The WEEK function returns the week number according to either a Sunday or Monday-based week convention, depending on […]
The MySQL TIMESTAMP function is a date and time function that is commonly used for working with date and time values in MySQL databases. It is often employed to store and retrieve timestamps, which represent a specific point in time, with both date and time components. Here is a brief overview of the MySQL TIMESTAMP […]
The MySQL TIME function is a built-in function that is used to extract the time portion from a datetime or timestamp expression. It is particularly useful when you have a datetime value and you want to isolate and work with only the time component. Syntax The basic syntax of the TIME function is as follows: […]
© MySQL Tutorial 2025.