SysUtcDate

Microsoft SQL Server docs on SysUtcDateTime

2005
2008
2012
2014
2016
2017
2019
2022

2005, 2008, 2012, 2014, 2016, 2017, 2019, 2022

SysUtcDate Date and Time Function

Use the SysUtcDateTime function to return the server's current date and time in UTC format (no timezone offset).

Microsoft SQL Server does not require a FROM clause to execute the SysUtcDateTime function, but dbExpression requires a FROM clause to execute any query. For this function to execute on it's own, a "dummy" FROM clause must be provided.

Syntax

db.fx.SysUtcDateTime()

Arguments

(none)

Returns

DateTime

Examples

Select Statement

Select the server's current date and time.

DateTime current = db.SelectOne(
        db.fx.SysUtcDateTime()
    )
    .From(dbo.Purchase) // <- "dummy" from clause
    .Execute();