Other CURRENT_TIMESTAMP SQL function

1. Usage of CURRENT_TIMESTAMP to show Order Processing Time

SQL Server Query 1

            
 WITH OrderProcessed AS (  

     SELECT OrderID,  

         DATEADD(HOUR, 2, OrderDate) AS OrderProcessedDate  

     FROM Orders  

     WHERE OrderID IN (10248, 10249, 10250, 10251)  

 )  

 SELECT  

     o.OrderID,  

     o.OrderDate,  

     op.OrderProcessedDate,  

     CASE  

         WHEN op.OrderProcessedDate IS NULL THEN 'Not Processed Yet'  

         ELSE CONCAT(DATEDIFF(MINUTE, OrderDate, op.OrderProcessedDate), ' Minutes')  

     END AS ProcessingTime,  

     CURRENT_TIMESTAMP AS QueryRunTime -- Get current time  

 FROM Orders o  

 LEFT JOIN OrderProcessed op ON op.OrderID = o.OrderID  

 WHERE o.OrderID IN (10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255);  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .WithCTETable(new Table("OrderProcessed"), new SqlQueryBuilder()  

         .Select().Column("OrderID", "OrderID")  

         .Column(new DATEADD(SqlDateInterval.hour, 2, new Column("OrderDate")), "OrderProcessedDate")  

         .From("Orders")  

         .Where(new Where(new IN(new Column("OrderID"), 10248, 10249, 10250, 10251)))  

     )  

     .Select().Columns("o.OrderID", "o.OrderDate", "op.OrderProcessedDate")  

     .Column(new CASE()  

         .When(new IS_NULL(new Column("op.OrderProcessedDate")))  

         .Then("Not Processed Yet")  

         .Else(new CONCAT(new DATEDIFF(SqlDateInterval.minute, new Column("OrderDate"), new Column("op.OrderProcessedDate")), "Minutes"))  

     , "ProcessingTime")  

     .Column(new CURRENT_TIMESTAMP(), "QueryRunTime")  

     .From("Orders", "o")  

     .Join(new List<IJoin>()  

     {  

         new LEFTJOIN().TableName(new Table("OrderProcessed","op"))  

         .On(new Column("op.OrderID").Equale(new Column("o.OrderID")))  

     })  

     .Where(new Where(new IN(new Column("o.OrderID"), 10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255)))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
WITH OrderProcessed
AS (SELECT OrderID AS OrderID,
           DATEADD(hour, @pMAIN_2602032113083154680, OrderDate) AS OrderProcessedDate
    FROM Orders
    WHERE OrderID IN (@pMAIN_2602032113083154681, @pMAIN_2602032113083154682, @pMAIN_2602032113083154683, @pMAIN_2602032113083154684))
SELECT o.OrderID,
       o.OrderDate,
       op.OrderProcessedDate,
       CASE WHEN op.OrderProcessedDate IS NULL THEN @pMAIN_2602032113083154685 ELSE CONCAT(DATEDIFF(minute, OrderDate, op.OrderProcessedDate), @pMAIN_2602032113083154686) END AS ProcessingTime,
       CURRENT_TIMESTAMP AS QueryRunTime
FROM Orders AS o
     LEFT OUTER JOIN
     OrderProcessed AS op
     ON op.OrderID = o.OrderID
WHERE o.OrderID IN (@pMAIN_2602032113083154687, @pMAIN_2602032113083154688, @pMAIN_2602032113083154689, @pMAIN_260203211308315468_10, @pMAIN_260203211308315468_11, @pMAIN_260203211308315468_12, @pMAIN_260203211308315468_13, @pMAIN_260203211308315468_14);


            
        

Parameters (If used)

Query Results 1: