Scalar FunctionsDate & Time Functions

startofday

Returns the start of the day for the given datetime.

Syntax

startofday(date, offset)

Prop

Type

Returns: datetime

print startofday(datetime(2024-06-08 06:00))

print_0 (datetime)
2024-06-08T00:00:00Z

now

Returns the current query timestamp as a datetime value.

startofmonth

Returns the start of the month for the given datetime.