Adding seconds to a timestamp

Question

I want to add seconds to a given timestamp.

An example :

This time:

Declare
       t1 timestamp = '1900-01-01 02:00:00';

Now I want to add 20 secondsat a given time.

In SQL Server, I used DATEADD. But I searched and found out that such a function is not provided by PostgreSQL.

What will be the solution?

Answer 1

Just add 20 seconds:

t1 := t1 + interval '20' second;

---

The assignment operator in PL / pgSQL is :=. =exists only for backward compatibility. Do not use it.