9.Db2下timestamp()函数用法
答:TIMESTAMPDIFF(K,CHAR(TS1 – TS2))
K
Date Part
256
Years
128
Quarters
64
Months
32
Weeks
16
Days
8
Hours
4
Minutes
2
Seconds
10.db2下如何进行字符串组合拼接?
答:使用‘||’处理,concat()函数
例如: DECLARE VC_SQL_STR VCHAR(100);
DECLARE VC_WHERE VCHAR(100);
DECLARE VC_FROM VCHAR(100);
SET VC_FROM = ‘ FROM XHZQ_DB.SYS_PARAMETER_TAB ‘;
SET VC_WHERE = ‘ WHERE VC_ID IS NULL ‘;
SET VC_SQL_STR = ‘ SELECT * ‘ || VC_FROM || VC_WHERE ;
上一页 [1] [2]
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18