📄 db2_utils.sql

📁 大家共享愉快, 共享愉快, 共享愉快, 共享愉快,共享愉快

💻 SQL

字号:

SELECT SUBSTR('asdfg',1,2) FROM SysIBM.SysDummy1;



SELECT TIMESTAMP('2006-01-22-12.00.00.000000') FROM SysIBM.SysDummy1;

SELECT CURRENT TIMESTAMP FROM SysIBM.SysDummy1;

SELECT USER FROM SysIBM.SysDummy1;
SELECT CURRENT USER FROM SysIBM.SysDummy1;
SELECT SYSTEM_USER FROM SysIBM.SysDummy1;

SELECT CURRENT SERVER FROM SysIBM.SysDummy1;
SELECT CURRENT SCHEMA FROM SysIBM.SysDummy1;



SELECT CURRENT TIMESTAMP FROM SysIBM.SysDummy1;
SELECT CURRENT TIMESTAMP FROM SysIBM.SysDummy1;




SELECT CURRENT TIMESTAMP FROM SysIBM.SysDummy1;

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -