CODEWITHSUNDEEP
postgresqlpostgresql-9.3
MAK
MAK

Reputation: 7270

Add seconds into timestamp

I want to add seconds into the given timestamp.

Example:

Given time:

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

Now I want to add some 20 seconds into the given time.

In SQL Server I have used DATEADD. But I searched and come to know that there is no such function provided by PostgreSQL.

What will be the solution?

Upvotes: 2

Views: 9298

Answers (1)

user330315
user330315

Reputation:

Just add the 20 seconds:

t1 := t1 + interval '20' second;

The assignment operator in PL/pgSQL is :=. The = is only there for backward compatibility. Don't use it.

Upvotes: 7

Related Questions