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_2509042321255551960, GETUTCDATE()) AS ShippedDate;
Parameters (If used)
Name | Value |
---|---|
@pMAIN_2509042321255551960 | 10 |
Query Results 1:
OrderDate | ShippedDate | |
---|---|---|
1 | 9/4/2025 5:51:25 PM | 9/14/2025 5:51:25 PM |