CONVERT function | SQL Tutorial and Query Example

Text copied!

CONVERT function

June 15, 2023, 7:16 p.m. under SQL
    • The syntax of the CONVERT function generally looks like this :
    Here's an example of how you might use the CONVERT function :

    1. Let's assume we have a table named "[Employees]".

    CONVERT(data_type, expression)
    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.
    CONVERT function 
    SELECT *, CONVERT(Date, Joining_Date) AS [Date]
FROM [Employees];
    CONVERT function

    Frequently Asked Questions :

    CONVERT() in SQL converts a value from one data type to another.
    CAST() and CONVERT() functions in SQL Server perform similar functions of converting data types, with slight differences in syntax and behavior.
    To convert a SQL query to another SQL query, you typically rewrite or modify the original query to achieve the desired output or functionality.
    The function to convert to a string in SQL varies based on the database system; for example, in SQL Server, you can use CONVERT() or CAST(), while in MySQL, you might use CONVERT() or CAST() as well.
    « Previous
    Next »
    RELATED :