Text copied!
CAST function
Hi! You should check
DATEDIFF function
post first.
In SQL, CAST function is used to convert a value from one data type to another data type.
The syntax of the CAST function generally looks like this :
CAST(expression AS data_type)
• Specify the 'expression/value' that you want to convert from one data type to another.
• Specify the desired 'data type' to which you want to convert the value or expression.
Here's an example of how you might use the CAST function :
1. Let's assume we have a table named "[Employees]".
2. Let's assume you want to convert the Joining_Date values from datetime format to date format.
3. Run below SQL statement :
SELECT *, CAST(Joining_Date AS date) AS [Date]
FROM [Employees];
4. In above statement, CAST function converts the Joining_Date values from datetime format to date format.
Remember :
Using this function in a select statement won't modify the [Employees] table directly, but it will only be reflected in the select statement's output.
To enhance your understanding of 'SQL functions', be sure to check out our next tutorial.
Frequently Asked Questions :
Thank You! You should check
TRY_CAST function
post next.