# otp.Operation.dt.timestamp_add #### \_DtAccessor.timestamp_add(date_part, number) Returns the specified datetime with the specified `number` interval (signed integer) added to the specified `date_part` of that datetime. * **Parameters:** * **number** ([*int*](https://docs.pip.distribution.sol.onetick.com/api/types/int.html.md#onetick.py.int) *|* [*Operation*](https://docs.pip.distribution.sol.onetick.com/api/operation/root.html.md#onetick.py.Operation) *|* [*Column*](https://docs.pip.distribution.sol.onetick.com/api/operation/root.html.md#onetick.py.Column)) -- Number of intervals to add. * **date_part** ([*str*](https://docs.pip.distribution.sol.onetick.com/api/operation/str/root.html.md#onetick.py.Operation.str) *|* [*Operation*](https://docs.pip.distribution.sol.onetick.com/api/operation/root.html.md#onetick.py.Operation) *|* [*Column*](https://docs.pip.distribution.sol.onetick.com/api/operation/root.html.md#onetick.py.Column)) -- Supported values are: : 'SQL_TSI_YEAR', 'SQL_TSI_QUARTER', 'SQL_TSI_MONTH', 'SQL_TSI_WEEK', 'SQL_TSI_DAY', 'SQL_TSI_HOUR', 'SQL_TSI_MINUTE', 'SQL_TSI_SECOND'. ### Examples Add one interval: ```pycon >>> data = otp.Ticks( ... X=[otp.dt(2020, 11, 12)] * 5, ... DATE_PART=['SQL_TSI_YEAR', 'SQL_TSI_QUARTER', 'SQL_TSI_MONTH', 'SQL_TSI_WEEK', 'SQL_TSI_DAY'] ... ) >>> data['Y'] = data['X'].dt.timestamp_add(data['DATE_PART'], 1) >>> otp.run(data)[['X', 'DATE_PART', 'Y']] X DATE_PART Y 0 2020-11-12 SQL_TSI_YEAR 2021-11-12 1 2020-11-12 SQL_TSI_QUARTER 2021-02-10 2 2020-11-12 SQL_TSI_MONTH 2020-12-12 3 2020-11-12 SQL_TSI_WEEK 2020-11-19 4 2020-11-12 SQL_TSI_DAY 2020-11-13 ``` Subtract one interval: ```pycon >>> data = otp.Ticks(X=[otp.dt(2020, 11, 11, 5, 4, 13)] * 3, ... DATE_PART=['SQL_TSI_HOUR', 'SQL_TSI_MINUTE', 'SQL_TSI_SECOND']) >>> data['Y'] = data['X'].dt.timestamp_add(data['DATE_PART'], -1) >>> otp.run(data)[['X', 'DATE_PART', 'Y']] X DATE_PART Y 0 2020-11-11 05:04:13 SQL_TSI_HOUR 2020-11-11 04:04:13 1 2020-11-11 05:04:13 SQL_TSI_MINUTE 2020-11-11 05:03:13 2 2020-11-11 05:04:13 SQL_TSI_SECOND 2020-11-11 05:04:12 ``` #### SEE ALSO **TIMESTAMPADD** OneTick function