DATE_SUB

MySQL

DATE_SUB(date, INTERVAL expr type)

• date: This parameter specifies the date from which the interval needs to be subtracted. It must be a valid date value that MySQL supports, including date expressions that return a date or datetime value.
• interval expr type: The INTERVAL keyword and its following expression (expr) mean to subtract a certain time interval from the date we have in the first parameter. It has two parts

Example

SELECT DATE_SUB('2008-01-02', INTERVAL 31 DAY);

Output

'2007-12-02'

Explanation

The above example demonstrates the usage of DATE_SUB function in MySQL. It subtracts a time interval from the provided date. In this case the interval is 31 days, subtracted from ‘2008-01-02’, which results in ‘2007-12-02’.

DuckDB

date_sub(part, startdate, enddate)

• part: VARCHAR
• startdate: TIMESTAMP WITH TIME ZONE
• enddate: TIMESTAMP WITH TIME ZONE

Example

SELECT date_sub('hour', TIMESTAMPTZ '1992-09-30 23:59:59', TIMESTAMPTZ '1992-10-01 01:58:00');