PARSE SQL function

1. Various usage of PARSE.

SQL Server Query 1

            
SELECT PARSE('09/05/2025' AS DATE USING 'fr-FR') AS ParsedFrenchDate,  

	PARSE('1234,56' AS DECIMAL(10, 2) USING 'fr-FR') AS ParsedFrenchNumber,  

	PARSE('1.234,56 €' AS MONEY USING 'de-DE') AS ParsedGermanMoney,  

	PARSE('1,234,567' AS BIGINT USING 'en-US') AS ParsedNumberWithSeparator,  

	PARSE('THURSDAY, 23 february 2023' AS datetime2 USING 'zh-CN') AS ZHCNResult,  

	PARSE('02/23/2023' AS DATETIME) AS DateTimeResult,  

	PARSE('123.000' AS INT) AS IntResult,  

	PARSE('56789' AS DECIMAL(8, 2)) AS DecimalResult,  

	PARSE('56789' AS MONEY) AS MoneyResult,  

	PARSE('30,000' AS decimal(8,2) USING 'en-US') AS InEnglish,  

	PARSE('30,000' AS decimal(8,2) USING 'fr-FR') AS InFrench;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

    .Column(new PARSE("09/05/2025", SqlDataType.DATE, "fr-FR"),"ParsedFrenchDate")  

    .Column(new PARSE("1234,56", SqlDataType.DECIMAL, Tuple.Create(10, 2), "fr-FR"), "ParsedFrenchNumber")  

    .Column(new PARSE("1.234,56 €", SqlDataType.MONEY, "de-DE"), "ParsedGermanMoney")  

    .Column(new PARSE("1,234,567", SqlDataType.BIGINT, "en-US"), "ParsedNumberWithSeparator")  

    .Column(new PARSE("THURSDAY, 23 february 2023", SqlDataType.DATETIME2, "zh-CN"), "ZHCNResult")  

    .Column(new PARSE("02/23/2023", SqlDataType.DATETIME), "DateTimeResult")  

    .Column(new PARSE("123.000", SqlDataType.INT), "IntResult")  

    .Column(new PARSE("56789", SqlDataType.DECIMAL, Tuple.Create(8,2)),"DecimalResult")  

    .Column(new PARSE("56789", SqlDataType.MONEY), "MoneyResult")  

    .Column(new PARSE("30,000", SqlDataType.DECIMAL, Tuple.Create(8, 2), "en-US"), "InEnglish")  

    .Column(new PARSE("30,000", SqlDataType.DECIMAL, Tuple.Create(8, 2), "fr-FR"), "InFrench")  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT PARSE (@pMAIN_2512060922051039950 AS DATE USING @pMAIN_2512060922051039951) AS ParsedFrenchDate,
       PARSE (@pMAIN_2512060922051039952 AS DECIMAL (10, 2) USING @pMAIN_2512060922051039953) AS ParsedFrenchNumber,
       PARSE (@pMAIN_2512060922051039954 AS MONEY USING @pMAIN_2512060922051039955) AS ParsedGermanMoney,
       PARSE (@pMAIN_2512060922051039956 AS BIGINT USING @pMAIN_2512060922051039957) AS ParsedNumberWithSeparator,
       PARSE (@pMAIN_2512060922051039958 AS DATETIME2 USING @pMAIN_2512060922051039959) AS ZHCNResult,
       PARSE (@pMAIN_251206092205103995_10 AS DATETIME) AS DateTimeResult,
       PARSE (@pMAIN_251206092205103995_11 AS INT) AS IntResult,
       PARSE (@pMAIN_251206092205103995_12 AS DECIMAL (8, 2)) AS DecimalResult,
       PARSE (@pMAIN_251206092205103995_13 AS MONEY) AS MoneyResult,
       PARSE (@pMAIN_251206092205103995_14 AS DECIMAL (8, 2) USING @pMAIN_251206092205103995_15) AS InEnglish,
       PARSE (@pMAIN_251206092205103995_16 AS DECIMAL (8, 2) USING @pMAIN_251206092205103995_17) AS inFrench;


            
        

Parameters (If used)

Query Results 1: