# Source: https://docs.oxla.com/sql-reference/sql-data-types/time-type/time-operators.md

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oxla.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Time Operators

Time operators in Oxla allow you to perform various operations on dates, times, and intervals. Here's a guide to using these operators:

## 1. DATE + INTEGER

Add a specific number of days to a date.

**Example**

```sql  theme={null}
select date '2022-03-15' + 14 as "result";
```

The result will be 14 days after '2022-03-15'.

```sql  theme={null}
   result   
------------
 2022-03-29
```

### 1.1. INTEGER + DATE

Adding and multiplying time operators can also be done in reverse order. For example, we add a number of days to a date in the format of `Integer + Date`.

```sql  theme={null}
select 14 + date '2022-03-15' AS "result";
```

The result will be the same, which is 14 days after '2022-03-15' is '2022-03-29'.

```sql  theme={null}
   result   
------------
 2022-03-29
```

## 2. DATE + INTERVAL

Add a specified interval to a date.

**Example**

```sql  theme={null}
select date '2022-03-15' + interval '3 months' as "result";
```

The result will be the date three months after '2022-03-15'.

```sql  theme={null}
           result           
----------------------------
 2022-06-15 00:00:00.000000
```

## 3. DATE - INTEGER

Subtract a certain number of days from a date.

**Example**

```sql  theme={null}
select date '2022-03-15' - 7 as "result";
```

The result will be 7 days before '2022-03-15'.

```sql  theme={null}
   result   
------------
 2022-03-08
```

## 4. DATE - INTERVAL

Subtract a specified interval from a date.

**Example**

```sql  theme={null}
select date '2022-03-15' - interval '2 hour' as "result";
```

The result will be the timestamp with two hours before '2022-03-15'.

```sql  theme={null}
           result           
----------------------------
 2022-03-14 22:00:00.000000
```

## 5. DATE - DATE

Subtract dates.

**Example**

```sql  theme={null}
select date '2023-03-15' - date '2023-01-10' as "result";
```

The number of days elapsed between '2023-03-15' and '2023-01-10' is 64 days.

```sql  theme={null}
 result 
--------
     64
```

## 6. DATE + TIME

Add a time-of-day to a date.

**Example**

```sql  theme={null}
select date '2010-05-20' + time '02:00' as "result";
```

The result will be a timestamp with the specified time added to the given date.

```sql  theme={null}
           result           
----------------------------
 2010-05-20 02:00:00.000000
```

## 7. TIME + INTERVAL

Add a certain interval to a given time.

**Example**

```sql  theme={null}
select time '12:30' + interval '1 hour' as "result";
```

The result will be the time 1 hour after '12:30'.

```sql  theme={null}
     result      
-----------------
 13:30:00.000000
```

## 8. TIME - INTERVAL

Subtract a specified interval from a given time.

**Example**

```sql  theme={null}
select time '18:45' - interval '45 minutes' as "result";
```

The result will be the time 18:00.

```sql  theme={null}
     result      
-----------------
 18:00:00.000000
```

## 9. TIME - TIME

Get a time difference by subtracting one time from another.

**Example**

```sql  theme={null}
select time '10:00' - TIME '08:20' as "result";
```

In this example, the time difference between the two provided times is 1 hour and 40 minutes.

```sql  theme={null}
     result      
-----------------
 01:40:00.000000
```

## 10. TIMESTAMP + INTERVAL

Add a timestamp and an interval.

**Example**

```sql  theme={null}
select timestamp '2021-01-05 12:00:00' + interval '5 days' as "result";
```

The result will be a new timestamp, adding 5 days to '2021-01-05 12:00:00'.

```sql  theme={null}
           result           
----------------------------
 2021-01-10 12:00:00.000000
```

## 11. TIMESTAMP - INTERVAL

Subtract an interval from a timestamp.

**Example**

```sql  theme={null}
select timestamp '2022-01-04 12:00:00' - interval '3 days' as "result";
```

In this example, it subtracts 3 days from '2022-01-04 12:00:00'.

```sql  theme={null}
           result           
----------------------------
 2022-01-01 12:00:00.000000
```

## 12. TIMESTAMP - TIMESTAMP

Get an interval by subtracting one timestamp from another.&#x20;

**Example**

```sql  theme={null}
select timestamp '2022-01-05 18:30:00' - timestamp '2022-01-01 12:00:00' as "result";
```

It gives the interval between the two timestamps, 102 hours and 30 minutes.

```sql  theme={null}
      result      
------------------
 102:30:00.000000
```

## 13. INTERVAL + INTERVAL

Add intervals.

**Example**

```sql  theme={null}
select interval '2 months 2 days' + interval '6 days' as "result";
```

It adds 6 days to 2 days, resulting in a total of 2 months and 8 days.

```sql  theme={null}
    result     
---------------
 2 mons 8 days
```

## 14. INTERVAL - INTERVAL

Subtract intervals.

**Example**

```sql  theme={null}
select interval '2 months' - interval '20 days' as "result";
```

It subtracts 20 days from 2 months.

```sql  theme={null}
     result      
-----------------
 2 mons -20 days
```

## 15. INTERVAL \* INTEGER

Multiply an interval by an integer.

**Example**

```sql  theme={null}
select interval '2 hours' * 3 as "result";
```

It multiplies '2 hours' by 3, the result is 6 hours.

```sql  theme={null}
     result      
-----------------
 06:00:00.000000
```

## 16. INTERVAL \* DOUBLE PRECISION

Multiply an interval by a scalar.

**Example**

```sql  theme={null}
select interval '2 hours' * 1.5 as "result";
```

It multiplies '2 hours' by 1.5, and returns 3 hours.

```sql  theme={null}
    result      
-----------------
 03:00:00.000000
```

## 17. INTERVAL / NUMBER

Divide an interval by an integer or scalar.

### a) Divide by an integer

```sql  theme={null}
select interval '1 hour' / 2 as "result";
```

It divides '1 hour' by 2, and returns 30 minutes.

```sql  theme={null}
    result      
-----------------
 00:30:00.000000
```

### b) Divide by a scalar

```sql  theme={null}
select interval '2 hours' / 1.5 as "result";
```

It divides '2 hours' by 1.5, and returns 1 hour 20 minutes.

```sql  theme={null}
     result      
-----------------
 01:20:00.000000
```