Add hour to current datetime(timestamp) in PostgreSQL

In order to add hour to current datetime(timestamp) in PostgreSQL we will be using the two approaches one by using the make_interval() and  other by Interval datatype. Here are examples of both the approaches. Also, we will look at how to Add hours to current datetime(timestamp) column in PostgreSQL table.

Add hours to current timestamp in PostgreSQL using INTERVAL data type:

We will be Using the INTERVAL data type to add hours to current datetime in PostgreSQL. When we add hours to current datetime(timestamp) using INTERVAL datatype the output will be in datetime(timestamp) format. In below example, we have added 1 hour to current datetime using Interval data type.

Example 1 using CURRENT_TIMESTAMP:

 

SELECT CURRENT_TIMESTAMP::timestamp + INTERVAL '1 hours' AS new_datetime

Output:

Example 2 using NOW():

 
SELECT NOW()::timestamp + INTERVAL '1 hours' AS new_datetime

Output:

Add hours to datetime in PostgreSQL using make_interval() function:

We will be Using the make_interval() function to add hours to datetime in PostgreSQL. When we add hours to datetime using the make_interval() function, the output will be in current datetime(timestamp) format. In below example, we have added 1 hour to timestamp

Example 1 using CURRENT_TIMESTAMP:

 

SELECT CURRENT_TIMESTAMP::timestamp + make_interval(hours => 1) as new_datetime

Output:

Example 2 using NOW():

 

SELECT NOW()::timestamp + make_interval(hours => 1) as new_datetime

Output:

Add hours to current datetime(timestamp) column in PostgreSQL table using Interval datatype:

We will be using below fruits table for our example to depict on how to add hours to current datetime(timestamp) column in PostgreSQL table.

fruits:

We have added 2 hours to datetime column using INTERVAL datatype in postgresql and new column named new_date is being created as shown below.

Example 1 : using NOW() function

 

select *,NOW()::timestamp as current_dt, NOW()::timestamp + INTERVAL '2 HOURS' as new_date from fruits

OR

Example 2 : using CURRENT_TIMESTAMP

 

select *,CURRENT_TIMESTAMP::timestamp as current_dt, CURRENT_TIMESTAMP::timestamp + INTERVAL '2 HOURS' as new_date from fruits

Output:

Add hours to datetime column in PostgreSQL table using make_interval() function:

We have added 2 hours to datetime column using make_interval() function in postgresql and new column named new_date is being created as shown below.

Example 1 : using NOW() function

 

select *,NOW()::timestamp as current_dt, NOW()::timestamp + make_interval(hours => 2) as new_date from fruits

OR

Example 2 : using CURRENT_TIMESTAMP

 
select *,CURRENT_TIMESTAMP::timestamp as current_dt, CURRENT_TIMESTAMP::timestamp + make_interval(hours => 2) as new_date from fruits

Output: