CONVERT SQL function

1. Usage of CONVERT to show more granular order info.

SQL Server Query 1

            
SELECT  

    OrderID,  

    CONVERT(VARCHAR, OrderDate, 107) AS FormattedOrderDate,  -- Convert to "Mon DD, YYYY" format  

    'Order ID: ' + CONVERT(VARCHAR, OrderID) + ', Date: ' + CONVERT(VARCHAR, OrderDate, 107) AS OrderInformation,  

    CustomerID  

FROM Orders;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

    .Column("OrderID", "OrderID")  

    .Column(new CONVERT(SqlDataType.VARCHAR, "", new Column("OrderDate"), ConvertStyle.HUNDERDANDSEVEN), "FormattedOrderDate")  

    .Column(new CONCAT(  

            "Order ID: ", new CONVERT(SqlDataType.VARCHAR, new Column("OrderID")),  

            "Date: ", new CONVERT(SqlDataType.VARCHAR, "", new Column("OrderDate"), ConvertStyle.HUNDERDANDSEVEN)  

        ), "OrderInformation")  

    .Column("CustomerID", "CustomerID")  

    .From("Orders")  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT OrderID AS OrderID,
       CONVERT (VARCHAR, OrderDate, 107) AS FormattedOrderDate,
       CONCAT(@pMAIN_2507200135336865900, CONVERT (VARCHAR, OrderID), @pMAIN_2507200135336865901, CONVERT (VARCHAR, OrderDate, 107)) AS OrderInformation,
       CustomerID AS CustomerID
FROM Orders;


            
        

Parameters (If used)

Query Results 1:

2. Usage of CONVERT to show formatted unit price.

SQL Server Query 2

            
SELECT  

    OrderID,  

    ProductID,  

    UnitPrice,  

    CONVERT(VARCHAR, UnitPrice, 1) AS FormattedUnitPrice  -- Style 1:  No commas, 2 decimal places  

FROM [Order Details];  

            
        

Create SQL query with SqlQueryBuilder 2

            
var (sql2, parameters2) = new SqlQueryBuilder()  

    .Select().Columns("OrderID", "ProductID", "UnitPrice")  

    .Column(new CONVERT(SqlDataType.VARCHAR, "", new Column("UnitPrice"), ConvertStyle.ONE), "FormattedUnitPrice")  

    .From("[Order Details]")  

    .Build();  

            
        

Query build by SqlQueryBuilder 2

            
SELECT OrderID,
       ProductID,
       UnitPrice,
       CONVERT (VARCHAR, UnitPrice, 1) AS FormattedUnitPrice
FROM [Order Details];


            
        

Parameters (If used)

Query Results 2: