startofday()
Learn how to use the startofday() function to return the start of the day for the given date.
Returns the start of the day containing the date, shifted by an offset, if provided.
Syntax
startofday(date [, offset ])
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| date | datetime | ✔️ | The date for which to find the start. |
| offset | int | The number of days to offset from the input date. The default is 0. |
Returns
A datetime representing the start of the day for the given date value, with the offset, if specified.
Example
range offset from -1 to 1 step 1
| project dayStart = startofday(datetime(2017-01-01 10:10:17), offset)
Output
| dayStart |
|---|
| 2016-12-31 00:00:00.0000000 |
| 2017-01-01 00:00:00.0000000 |
| 2017-01-02 00:00:00.0000000 |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.