timestamp

SELECT current_timestamp current_timestamp + '2 year' current_timestamp + '-3 month' current_timestamp + '4 days' current_timestamp + '-5 hour' current_timestamp + '6 minute' current_timestamp + '-7 second'

</p> <p></p><div class="txc-textbox" style="border: 1px dashed rgb(243, 197, 52); background-color: rgb(254, 254, 184); padding: 10px;"><p>SELECT alarm_time</p> <p><span class="Apple-tab-span" style="white-space:pre"> </span>, current_timestamp</p> <p><span class="Apple-tab-span" style="white-space:pre"> </span>, current_timestamp + '-60 minutes'</p> <p><span class="Apple-tab-span" style="white-space:pre"> </span>, current_timestamp - alarm_time as diff</p> <p><span class="Apple-tab-span" style="white-space:pre"> </span>, CASE WHEN current_timestamp - alarm_time < '60 minute' THEN 'NEW'</p> <p><span class="Apple-tab-span" style="white-space:pre"> </span>ELSE 'OLD'</p> <p><span class="Apple-tab-span" style="white-space:pre"> </span>END</p> <p><span class="Apple-tab-span" style="white-space:pre"> </span>FROM ALARM_LOG;</p></div><p><br /></p> <p><br /></p> <p><br /></p> <p></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p><br /></p> <p></p>