Scalar FunctionsDate & Time Functions

startofyear

Returns the start of the year for the given datetime.

Syntax

startofyear(date, offset)

Prop

Type

Returns: datetime

print startofyear(datetime(2024-06-15))

print_0 (datetime)
2024-01-01T00:00:00Z

startofweek

Returns the start of the week for the given datetime.

todatetime

Convert the input to a datetime.