Text copied!
CONVERT function
Hi! You should check
TRY_CAST function
post first.
In SQL, CONVERT function is used to convert a value from one data type to another data type.
The syntax of the CONVERT function generally looks like this :
CONVERT(data_type, expression)
• 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 CONVERT 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 *, CONVERT(Date, Joining_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_CONVERT function
post next.