How to round time in increments of 15 minutes?

Question

PostgreSQL

For example 14:44:43 = 14:45:00. For example 14:24:43 = 14:30:00

Answer 1

found a solution

(date_trunc('hour', (now() AT TIME ZONE 'Europe/Moscow')::time) +
        ceil(date_part('minute', (now() AT TIME ZONE 'Europe/Moscow')::time)::decimal / 15) * interval '15 min')::time

Answer 2

time as a TIME string or a TIMESTAMP number?