Postgres offers numerous temporal data types that assist us in storing or manipulating the DateTime values efficiently. The built-in functions and operators of Postgres allow us to perform numerous tasks on DateTime values. Minus “-” is one of the built-in Postgres operators that allow us to subtract the specific minutes from a DateTime value.
The minus “-” operator has extended functionalities, however, this write-up explains how to subtract minutes from a time, date, timestamp, or interval using the “-” operator.
How to Subtract Minutes From a Time Using “-” Operator?
To subtract minutes from a time, specify the “-” sign between the given times. We can specify the intervals while subtracting the DateTime values.
Example 1: Subtracting Minutes From a Specific Time
In the below coding example, “19” minutes are subtracted from the given time:
SELECT TIME '03:08' - INTERVAL '19 Minutes';
In the above snippet, the TIME and INTERVAL represent built-in temporal data types.
Nineteen minutes have been subtracted from the given time.
Example 2: Subtracting Minutes From Current Time
In the following example code, “15” minutes are subtracted from the current time:
SELECT CURRENT_TIME, CURRENT_TIME - INTERVAL '15 Minutes' AS subtracted_time;
The specified minutes have been subtracted from the current time.
Example 3: Subtracting Minutes From a Specific Timestamp
Let’s learn how to subtract “55” minutes from a particular timestamp:
SELECT TIMESTAMP '2022-12-31 23:30:30' - INTERVAL '55 Minutes';
The specified minutes have been successfully subtracted from the given timestamp.
Example 4: Subtracting Minutes From Current Timestamp
In this example, “15” minutes are subtracted from the current timestamp:
SELECT CURRENT_TIMESTAMP - INTERVAL '15 Minutes';
Fifteen minutes have been successfully subtracted from the current timestamp.
Example 5: Subtracting Minutes From a Specific Interval
Let’s learn how to subtract minutes from a specific interval using the “-” operator:
SELECT INTERVAL '5 years 4 days 2 hours 10 minutes' - INTERVAL '17 Minutes';
“17” minutes have been successfully subtracted from the given interval using the “-” operator.
Example 6: Subtracting Minutes FROM Current Date
In the below snippet, “75” minutes are subtracted from the current date using the “-” operator:
SELECT CURRENT_DATE - INTERVAL '75 Minutes';
The output demonstrates that the specified minutes have been successfully subtracted from the current date.
Example 7: Subtracting Seconds From Specific Minutes
In the below code, “130” seconds are subtracted from the given minutes using the “-” operator:
SELECT TIME '00:09:00' - INTERVAL '380 Seconds';
“380” seconds have been subtracted from the given minutes.
Conclusion
In PostgreSQL, the “-” operator is used to subtract minutes from the current or specific DateTime values. Where the DateTime value can be a date, interval, time, or timestamp. We can specify the intervals while subtracting the DateTime values. The minus “-” operator has extended functionalities, however, in this post, we have explained a few use cases of the “-” operator, such as how to subtract minutes from a time, date, timestamp, or interval using the “-” operator.
