Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this article
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Calculates a new datetime from a specified period multiplied by a specified amount, added to, or subtracted from a specified datetime.
datetime_add(
period,
amount,
datetime)
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
period | string |
✔️ | The length of time by which to increment. |
amount | int |
✔️ | The number of periods to add to or subtract from datetime. |
datetime | datetime |
✔️ | The date to increment by the result of the period x amount calculation. |
Possible values of period:
- Year
- Quarter
- Month
- Week
- Day
- Hour
- Minute
- Second
- Millisecond
- Microsecond
- Nanosecond
A datetime after a certain time/date interval has been added.
print year = datetime_add('year',1,make_datetime(2017,1,1)),
quarter = datetime_add('quarter',1,make_datetime(2017,1,1)),
month = datetime_add('month',1,make_datetime(2017,1,1)),
week = datetime_add('week',1,make_datetime(2017,1,1)),
day = datetime_add('day',1,make_datetime(2017,1,1)),
hour = datetime_add('hour',1,make_datetime(2017,1,1)),
minute = datetime_add('minute',1,make_datetime(2017,1,1)),
second = datetime_add('second',1,make_datetime(2017,1,1))
Output
year | quarter | month | week | day | hour | minute | second |
---|---|---|---|---|---|---|---|
2018-01-01 00:00:00.0000000 | 2017-04-01 00:00:00.0000000 | 2017-02-01 00:00:00.0000000 | 2017-01-08 00:00:00.0000000 | 2017-01-02 00:00:00.0000000 | 2017-01-01 01:00:00.0000000 | 2017-01-01 00:01:00.0000000 | 2017-01-01 00:00:01.0000000 |
print year = datetime_add('year',-5,make_datetime(2017,1,1)),
quarter = datetime_add('quarter',12,make_datetime(2017,1,1)),
month = datetime_add('month',-15,make_datetime(2017,1,1)),
week = datetime_add('week',100,make_datetime(2017,1,1))
Output
year | quarter | month | week |
---|---|---|---|
2012-01-01T00:00:00Z | 2020-01-01T00:00:00Z | 2015-10-01T00:00:00Z | 2018-12-02T00:00:00Z |