GETDATE SQL function

1. Usage of GETDATE.

SQL Server Query 1

            
SELECT GETDATE() AS OrderDate, DATEADD(DD, 10, GETDATE()) AS ShippedDate;  

            
        

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  

    .Select()  

    .Column(new GETDATE(), "OrderDate")  

    .Column(new DATEADD(SqlDateInterval.dd, 10, new GETDATE()), "ShippedDate")  

    .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT GETDATE() AS OrderDate,
       DATEADD(dd, @pMAIN_2603210352558419730, GETDATE()) AS ShippedDate;


            
        

Parameters (If used)

Query Results 1: