(TIL) Snowflake: Increment date and time values with dateadd

less than 1 minute read

// 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.

Comments