使用 lower()
和upper()
。
像这样:
SELECT lower(tsrng) AS start, upper(tsrng) AS end
FROM (
SELECT tstzrange('2017-05-05 12:00:05', '2017-05-05 16:00:05', '[)') AS tsrng
) sub;
或您的示例:
select *, lower(timerange) as t_start, upper(timerange) as t_end from schedules;