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.viewsselect * from syscat.indexs--转换截取--select substr(cast(20100930 as char(100)),5,2)fromsysibm.sysdummy1
页:
[1]