CONVERSOES CAST, CONVERT, TRY_CAST, TRY_CONVERT.sql

/*
    CAST (col_name) AS (data_type)
    CONVERT(data_type, col_name, [style])
*/

USE AdventureWorks2022
GO

SELECT (SELECT '33') + (SELECT '37')

SELECT (SELECT CAST('33' AS INT)) + (SELECT CAST('37' AS INT))
SELECT CAST('20010219' AS DATE)

-- SELECT GETDATE()

SELECT CONVERT(VARCHAR(10), GETDATE(), 103)

SELECT CONVERT(VARCHAR(10), CAST('20010219' AS DATE), 3)
SELECT CONVERT(INT, '6526164') + 6

SELECT TRY_CONVERT(DATE, '14/02/2017', 101) AS COL,
        TRY_CONVERT(DATE, '02/14/2017', 101) AS COL2

SELECT CAST('45F' AS SMALLMONEY) AS CONV
SELECT TRY_CAST('45F' AS SMALLMONEY) AS CONV

SELECT (SELECT CAST(GETDATE() AS VARCHAR(25))) + ' 6565'

SELECT TRY_CAST('6528.56' AS FLOAT)

SELECT TRY_CAST('256' AS TINYINT)