Scalar FunctionsDate & Time Functions
endofmonth
Returns the end of the month for the given datetime.
Syntax
endofmonth(date, offset)Parameters
Prop
Type
Returns: datetime
Examples
Example 1 — End of the month the Vikings struck Lindisfarne
print endofmonth(datetime(2024-06-08))| print_0 (datetime) |
|---|
| 2024-06-30T23:59:59.9999999Z |