http://lhbthanks.iteye.com/blog/1667174
http://blog.csdn.net/amaryh/article/details/5282634
select sendtime, sheetcompletelimit, ((sheetcompletelimit-sendtime)::interval second(9) to second ::char(20) ::integer), extend(sendtime,hour to hour)
from businesschange_main where sendtime > '2013-07-12 15:59:59'
2013-7-12 下午4:17:25'2013-7-19 下午3:50:01'603156
2013-7-12 下午4:28:25&
http://blog.csdn.net/amaryh/article/details/5282634
http://www.forumtopics.com/busobj/viewtopic.php?p=507955&sid=ecc0559a028f637dcd6459a91a3fbbed
两个时间段函数相减,得到的秒数。 extend(sendtime,hour to hour) 截取小时数select sendtime, sheetcompletelimit, ((sheetcompletelimit-sendtime)::interval second(9) to second ::char(20) ::integer), extend(sendtime,hour to hour)
from businesschange_main where sendtime > '2013-07-12 15:59:59'
2013-7-12 下午4:17:25'2013-7-19 下午3:50:01'603156
2013-7-12 下午4:28:25&