Snowflake: Increment date and time values with dateadd

// Add two years to the current date:
select dateadd(year, 2, current_date());

// Subtract two seconds to the current date and time:
select dateadd(second, -2, current_timestamp());

Via Snowflake Docs.