Informix-4GL 簡單資料型別《 TIME DATA 》( 三 )－M@nGo Learning Notes

INFORMIX-4GL 簡單資料型別《 TIME DATA 》

三、INTERVAL

語法	INTERVAL largestTime( m ) TO smallestTime( n )
	m : 設定計算起始時間的位數 n : 設定計算結束時間的小數點位數，僅適用於 FRACTION
時間群組	YEAR 、 MONTH
	DAY 、 HOUR 、 MINUTE 、 SECOND 、 FRACTION
使用方法	用於計算 DATE 、DATETIME 、 INTERVAL 的時間間距可按任何順序排列計算結果為正值或負值的 INTERVAL 資料型別
注意事項	只能同時運用上述其中一群組
範例一	DEFINE timeInterval DATETIME YEAR TO MONTH timeInterval = DATETIME (2003-9) YEAR TO MONTH - DATETIME (2003-8) YEAR TO MONTH DISPLAY timeInterval =>> 0-01
範例二	DEFINE timeInterval INTERVAL YEAR TO MONTH LET timeInterval = DATETIME (2005-09) YEAR TO MONTH - DATETIME (2005-10) YEAR TO MONTH DISPLAY timeInterval =>> -0-01
範例三	DEFINE timeInterval INTERVAL DAY TO SECOND ... LET timeInterval = DATETIME (23 12:00:00) DAY TO SECOND - DATETIME (14 12:30:00) DAY TO SECOND DISPLAY timeInterval =>> 8 23:30:00
範例四	DEFINE timeInterval INTERVAL DAY TO SECOND LET timeInterval = DATETIME (22 12:00:00) DAY TO SECOND - DATETIME (22 12:30:00) DAY TO SECOND DISPLAY timeInterval =>> -0 00:30:00
範例五	DEFINE timeInterval INTERVAL YEAR TO YEAR LET timeInterval = EXTEND ( DATE ('2007-02-05'), YEAR TO YEAR ) - DATE ('1968-06-04') DISPLAY timeInterval =>> 39
範例六	DEFINE timeInterval INTERVAL MONTH TO MONTH LET timeInterval = DATE ('2007-02-05') - DATE ('2007-06-04') DISPLAY timeInterval =>> -4
範例七	DEFINE timeInterval INTERVAL DAY(5) TO DAY LET timeInterval = ( DATE ('2007/02/05') - DATE ('1968/06/04') ) UNITS DAY DISPLAY timeInterval =>> 14125
範例八	DEFINE timeInterval INTERVAL YEAR TO MONTH LET timeInterval = EXTEND ( DATE ('2007-02-05'), YEAR TO MONTH ) - DATE ('1969-06-04') DISPLAY timeInterval =>> 37-08
範例九	DEFINE timeInterval INTERVAL MINUTE(3) TO FRACTION(4) LET timeInterval = INTERVAL (100:30.0005) MINUTE(3) TO FRACTION(4) - INTERVAL (120.01) SECOND(3) TO FRACTION DISPLAY timeInterval =>> 98:29.9905
範例十	DEFINE timeInterval INTERVAL MINUTE TO FRACTION(4) LET timeInterval = INTERVAL (15:30.0002) MINUTE TO FRACTION(4) * 2.5 DISPLAY timeInterval =>> 38:45.0005
範例十一	DEFINE timeInterval DATETIME YEAR TO DAY LET timeInterval = DATETIME (2000-8-1) YEAR TO DAY + INTERVAL (3-5) YEAR TO MONTH DISPLAY timeInterval =>> 2004-01-01
範例十二	DEFINE timeInterval DATETIME YEAR TO MINUTE LET timeInterval = EXTEND ( DATETIME (2008-8-1) YEAR TO DAY, YEAR TO MINUTE ) - INTERVAL (720) MINUTE(3) TO MINUTE DISPLAY timeInterval =>> 2008-07-31 12:00