如何从postgres日期时间中减去秒数 [英] How to subtract seconds from postgres datetime

问题描述

假设我有一个 dateTime 类型的列，其值为2014-04-14 12:17:55.772"&我需要从中减去秒2"秒才能得到像12:17:53"这样的o/p.

Say I have column of type dateTime with value "2014-04-14 12:17:55.772" & I need to subtract seconds "2" seconds from it to get o/p like this "12:17:53".

推荐答案

select '2014-04-14 12:17:55.772'::timestamp - interval '2 seconds';

为了更大的灵活性，可以增加间隔

For greater flexibility it is possible to mutiply the interval

select '2014-04-14 12:17:55.772'::timestamp - 2 * interval '1 second';

如果你想截断到第二个

select date_trunc(
    'second', 
    '2014-04-14 12:17:55.772'::timestamp - interval '2 seconds'
);

这篇关于如何从postgres日期时间中减去秒数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！