GETUTCDATE SQL function


1. Usage of GETUTCDATE.

SQL Server Query 1

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

Create SQL query with SqlQueryBuilder 1

            
var (sql1, parameters1) = new SqlQueryBuilder()  
.Select()
.Column(new GETUTCDATE(), "OrderDate")
.Column(new DATEADD(SqlDateInterval.dd, 10, new GETUTCDATE()), "ShippedDate")
.Build();

Query build by SqlQueryBuilder 1

            
SELECT GETUTCDATE() AS OrderDate,
       DATEADD(dd, @pMAIN_2507192019004120640, GETUTCDATE()) AS ShippedDate;


            
        

Parameters (If used)

Name Value
@pMAIN_2507192019004120640 10

Query Results 1:

  OrderDate ShippedDate
1 7/19/2025 2:49:00 PM 7/29/2025 2:49:00 PM