風(fēng)哥IBM DB2數(shù)據(jù)庫(kù)培訓(xùn)實(shí)戰(zhàn)教程(速成版)
timestampdiff (128, char(timestamp('') - timestamp(''))) AS "間隔季度",
timestampdiff (64, char(timestamp('') - timestamp(''))) AS "間隔月",
timestampdiff (32, char(timestamp('') - timestamp(''))) AS "間隔周",
timestampdiff (16, char(timestamp('') - timestamp(''))) AS "間隔日",
timestampdiff (8, char(timestamp('') - timestamp(''))) AS "間隔時(shí)",
timestampdiff (4, char(timestamp('') - timestamp(''))) AS "間隔分",
timestampdiff (2, char(timestamp('') - timestamp(''))) AS "間隔秒"
標(biāo)簽: