Scalar FunctionsDate & Time Functions

endofyear

Returns the end of the year for the given datetime.

Syntax

endofyear(date, offset)

Prop

Type

Returns: datetime

print endofyear(datetime(2024-11-01))

print_0 (datetime)
2024-12-31T23:59:59.9999999Z

endofweek

Returns the end of the week for the given datetime.

format_datetime

Formats a datetime value as a string.