https://www.sqlines.com/ 2026-05-23T16:52:06+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2017-12-29T14:53:21+00:00 https://www.sqlines.com/sybase-ads-to-sql-server/timestampadd?rev=1514559201&do=diff In Sybase Advantage Database you can use TIMESTAMPADD function to add an interval to the datetime value. In Microsoft SQL Server you can use DATEADD function, but note that the interval unit specifiers are different: Sybase ADS: -- Add 1 day to the current datetime SELECT TIMESTAMPADD(SQL_TSI_DAY, 1, CURRENT_TIMESTAMP()); # 2017-12-30 17:27:11.343 -- Subtract 1 day from the current datetime SELECT TIMESTAMPADD(SQL_TSI_DAY, -1, CURRENT_TIMESTAMP()); # 2017-12-28 17:27:11.343