db2查询函数和存储过程
--查找某个存储过程select * from syscat.procedures where procschema='PAS' and procname='sp_insert_xtrz'
--查找某个函数
select * from syscat.functions where funcschema='PAS' and funcname='sp_insert_xtrz'
--=================
--查找当前时间
--取得当前年月日：
--取得当前时分秒：
--取得当前年月日时分秒
--==================
SELECT current date FROM sysibm.sysdummy1
SELECT current time FROM sysibm.sysdummy1
SELECT current timestamp FROM sysibm.sysdummy1
SELECT F_ISDATE(20100231) FROM sysibm.sysdummy1
--查找试图
select * from syscat.views
select * from syscat.indexs
--转换截取--
select substr(cast(20100930 as char(100)),5,2)fromsysibm.sysdummy1
页:
[1]