How to change only time while keeping the date same in timestamp type I have timestamp column used for scheduling calendar events. I would like to change only the time part while retaining the date part untouched. 

How can I possibly do it? I'm on postgresql

Current:

2017-07-01 00:00:00


To:

2017-07-01 17:00:00
Add the desired INTERVAL

select date + interval '5 hour'


Have a look at: Date/Time Functions and Operators on Postgres documentation.

select a.MyDate + interval '5 hour' as Result_Date
from (select '2017-07-01 00:00:00'::date myDate) a

|result_date        |
|:------------------|
|2017-07-01 05:00:00|


dbfiddle here