Operators

Subtopics

EdgeQL Tutorial

Operators

Date and time types support the addition or subtraction of various durations. Note that this operation produces the result of the same type as the other operand:

Input

SELECT <datetime>'2020-03-15 12:34:56+00' +
       <duration>'2h 15m';

SELECT <datetime>'2020-03-15 12:34:56+00' +
       <duration>'2h 15m';

Run

Output

Press the 'Run' button to evaluate the input

Input

SELECT <cal::local_datetime>'2020-03-15 12:34:56' +
       <duration>'2h 15m';

SELECT <cal::local_datetime>'2020-03-15 12:34:56' +
       <duration>'2h 15m';

Run

Output

Press the 'Run' button to evaluate the input

Input

SELECT <cal::local_time>'12:34:56' + <duration>'2h 15m';

SELECT <cal::local_time>'12:34:56' + <duration>'2h 15m';

Run

Output

Press the 'Run' button to evaluate the input

Input

SELECT <cal::local_date>'2020-03-15' - <duration>'24h';

SELECT <cal::local_date>'2020-03-15' - <duration>'24h';

Run

Output

Press the 'Run' button to evaluate the input

Of course, durations can be added and subtracted from each other:

Input

SELECT <duration>'24h' - <duration>'3h 20m';

SELECT <duration>'24h' - <duration>'3h 20m';

Run

Output

Press the 'Run' button to evaluate the input

Finally, it's possible to subtract one datetime value from another to get a duration, but this operation is illegal for any of the cal types:

Input

SELECT <datetime>'2020-03-15 12:34:56+00' -
       <datetime>'2020-03-15 11:45:16+00';

SELECT <datetime>'2020-03-15 12:34:56+00' -
       <datetime>'2020-03-15 11:45:16+00';

Run

Output

Press the 'Run' button to evaluate the input

Input

# This is an error:
SELECT <cal::local_datetime>'2020-03-15 12:34:56' -
       <cal::local_datetime>'2020-03-15 11:45:16';

# This is an error:
SELECT <cal::local_datetime>'2020-03-15 12:34:56' -
       <cal::local_datetime>'2020-03-15 11:45:16';

Run

Output

Press the 'Run' button to evaluate the input

Prev Next