how to change only date while keeping the time in timestamp postgres?

Question

I would like to change only the date part while retaining the time part untouched on postgresql datetime column?

2019-09-02 10:00:00

to

2019-10-26 10:00:00

add an interval. select '2019-09-02 10:00:00'::timestamp + '54 days'::interval; — Jasen
– Jasen, Commented Oct 26, 2019 at 6:44
i want to update date of that entire column by not changing the time — Dilu Vinayan
– Dilu Vinayan, Commented Oct 26, 2019 at 6:53

Gordon Linoff · Accepted Answer · 2019-10-26 12:09:32Z

1

You don't specify the logic you want to use. If you want to add or subtract an interval, you can use:

select '2019-09-02 10:00:00'::timestamp + interval '1 month 24 day'

If you want to directly specify the second date:

select '2019-10-26'::timestamp + ('2019-09-02 10:00:00'::timestamp)::time

answered Oct 26, 2019 at 12:09

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1