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_2507200144082657940 AS DATE USING @pMAIN_2507200144082657941) AS ParsedFrenchDate,
       PARSE (@pMAIN_2507200144082657942 AS DECIMAL (10, 2) USING @pMAIN_2507200144082657943) AS ParsedFrenchNumber,
       PARSE (@pMAIN_2507200144082657944 AS MONEY USING @pMAIN_2507200144082657945) AS ParsedGermanMoney,
       PARSE (@pMAIN_2507200144082657946 AS BIGINT USING @pMAIN_2507200144082657947) AS ParsedNumberWithSeparator,
       PARSE (@pMAIN_2507200144082657948 AS DATETIME2 USING @pMAIN_2507200144082657949) AS ZHCNResult,
       PARSE (@pMAIN_250720014408265794_10 AS DATETIME) AS DateTimeResult,
       PARSE (@pMAIN_250720014408265794_11 AS INT) AS IntResult,
       PARSE (@pMAIN_250720014408265794_12 AS DECIMAL (8, 2)) AS DecimalResult,
       PARSE (@pMAIN_250720014408265794_13 AS MONEY) AS MoneyResult,
       PARSE (@pMAIN_250720014408265794_14 AS DECIMAL (8, 2) USING @pMAIN_250720014408265794_15) AS InEnglish,
       PARSE (@pMAIN_250720014408265794_16 AS DECIMAL (8, 2) USING @pMAIN_250720014408265794_17) AS inFrench;


            
        

Parameters (If used)

Query Results 1: