最新DB2数据库资料整理汇总实用版.docxVIP

)currentdatcurrentdate+1currentdate+1YEARcurrentdate+3YEARS+2MONTHS+15DAYScurrenddmailvarchar(128);1删除列:oracle

)currentdatcurrentdate+1currentdate+1YEARcurrentdate+3YEARS+2MONTHS+15DAYScurren

ddmailvarchar(128);1删除列:oracle与mysql相同:altertabletestdropcolumnmail;仅供学习与交流，如有侵权

值。数字可以为零，或者在从-1.79769E+308到-2.225E-307或从2.225E-307到1.79769E+308的范围内。仅供学习与交流，如有侵权

字符串，最长可达32,672字节。*LONGVARCHAR：LONGVARCHAR类型的字符串是变长字符串，最长可达32,700字节。*字符大对象字符串(Cha

DB2数据库资料整理

ttime+5HOUR-3MINUTES+10SECONDSdays(currentdate)-days(date(1999-10-22))char(cur的范围是从1到

ttime+5HOUR-3MINUTES+10SECONDSdays(currentdate)-days(date(1999-10-