Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/mysql/mysql-datatype-functions/ below:

MySQL Datatype Functions - GeeksforGeeks

Last Updated : 23 Jul, 2025

MySQL datatype functions can therefore be described as crucial elements in data processing in databases. These functions enable operations that can translate, alter and verify if basic data types such as string, number, date and binary data are sane. Due to the extent of the provided functionalities, these functions facilitate the processing and searching of data as well as avoiding such challenges as duplication of data.

In this article, We will learn about the MySQL Datatype Functions by understanding the various functions along with the examples and so on.

• MySQL Datatype Functions are peculiar functions that work on MySQL data types for handling and transforming them where required.
  
• These functions include functions on string, numeric, date and binary data that help improve data manipulation and quality and aid database query and maintenance.

Here, we will discuss some of the most commonly used datatype functions along with their syntax:

• CONCAT(): It Concatenates two or more strings.

SELECT CONCAT('Hello', ' ', 'World') AS greeting;

• LENGTH(): It Returns the length of a string in bytes.

SELECT LENGTH('Hello') AS length_of_string;

• ABS(): It Returns the absolute value of a number.

SELECT ABS(-10) AS absolute_value;

• ROUND(): It Rounds a number to the specified number of decimal places.

SELECT ROUND(3.14159, 2) AS rounded_value;

• CURDATE(): It Returns the current date.

SELECT CURDATE() AS current_date;

• DATEDIFF(): It Returns the difference in days between two dates.

SELECT DATEDIFF('2024-07-01', '2024-06-01') AS days_difference;

• BIN(): It Returns a string representation of the argument as a binary number.

SELECT BIN(12) AS binary_representation;

• HEX(): It Returns a string representation of the argument as a hexadecimal number.

SELECT HEX(255) AS hexadecimal_representation;

Let's concatenate strings and find the length of a string:

SELECT CONCAT('MySQL', ' ', 'Datatype', ' ', 'Functions') AS concatenated_string,

LENGTH('MySQL Datatype Functions') AS string_length;

Output:

Explanation: This query concatenates the strings "MySQL", "Datatype", and "Functions" with spaces in between and returns the length of the concatenated string

Let's find the absolute value and round a number:

SELECT ABS(-25) AS absolute_value,

ROUND(123.456789, 3) AS rounded_value;

Explanation: This query returns the absolute value of -25 and rounds the number 123.456789 to three decimal places.

Output:

Let's get the current date and the difference in days between two dates:

SELECT CURDATE() AS current_date,

DATEDIFF('2024-07-27', '2024-07-20') AS days_difference;

Output:

Explanation: This query returns the current date and the number of days between July 20, 2024, and July 27, 2024.

Let's convert numbers to binary and hexadecimal representations:

SELECT BIN(10) AS binary_representation,

HEX(255) AS hexadecimal_representation;

Output:

Explanation: This query returns the binary representation of 10 and the hexadecimal representation of 255.

The MySQL datatype functions are perhaps the most significant and useful category of MySQL functions when it comes to working on various datatypes in your database. From string operations to numerical computations and date manipulations, these functions improve different computations effectiveness and productivity. With these functions you are able to improve the data quality to execute complicated conversions and to enhance the utilization of databases.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4