PostgreSQL Time Calculation

In PostgreSQL, you can directly add or subtract timestamp:

Timestamp + interval

 

Example:

Select now (): Timestamp + '1 year'; <br/> select now (): Timestamp + '1 month'; <br/> select now ():: timestamp + '1 Day'; <br/> select now (): Timestamp + '1 hour '; <br/> select now ():: timestamp + '1 min '; <br/> select now (): Timestamp + '1 sec'; <br/> select now ():: timestamp + '1 year 1 month 1 day 1 hour 1 min 1 sec '; <br/> select now (): Timestamp + (COL | 'day '):: interval from table

 

Note:

• For addition and subtraction with table fields, for example, in the last example, You need to convert the concatenated stringInterval

  Type.