Poznámka
Na prístup k tejto stránke sa vyžaduje oprávnenie. Môžete sa skúsiť prihlásiť alebo zmeniť adresáre.
Na prístup k tejto stránke sa vyžaduje oprávnenie. Môžete skúsiť zmeniť adresáre.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Provides the end of the day containing the date, shifted by an offset, if provided.
Syntax
endofday(date [, offset])
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime |
✔️ | The date to find the end of. |
| offset | int |
The number of offset days from date. Default is 0. |
Returns
Returns a datetime representing the end of the day for the given date value, with the offset, if specified.
Examples
The following example returns the end of the day for the specified date.
range offset from -1 to 1 step 1
| project dayEnd = endofday(datetime(2017-01-01 10:10:17), offset)
Output
| dayEnd |
|---|
| 2016-12-31 23:59:59.9999999 |
| 2017-01-01 23:59:59.9999999 |
| 2017-01-02 23:59:59.9999999 |