璇讳功涔嬫硶
,
鍦ㄥ惊搴忚�屾笎杩?/p>
,
鐔熻鑰岀簿鎬?/p>
1.db2 sql
璇彞涓绠椾袱涓棩鏈熺浉宸殑璇硶
锛?/p>
1
锛?/p>
timestampdiff(8,char(
缁撴潫鏃堕棿
-
寮�濮嬫椂闂?/p>
) )
锛堝姞鏃跺垎绉掕绠楋紝浼氳垗鍘婚浂鏁帮級鍊?/p>
涓?/p>
744
灏忔椂
锛?/p>
2
锛?/p>
(days(
缁撴潫鏃堕棿
)-days(
寮�濮嬫椂闂?/p>
))*24
+hour(
缁撴潫鏃堕棿
)-hour(
寮�濮嬫椂闂?/p>
)
锛堜笉鍔?/p>
鏃跺垎绉掕绠楋級鍊间负
745
灏忔椂
锛?/p>
3
锛?/p>
Days
锛堢粨鏉熸棩鏈燂級
-days
锛堝紑濮嬫棩鏈燂級鐨勫�间负
31
澶?/p>
锛?/p>
4
锛?/p>
Day(
缁撴潫鏃ユ湡
)-day
锛堝紑濮嬫棩鏈燂級鐨勫�间负
1
澶?/p>
锛?/p>
5
锛?/p>
Hour
锛堢粨鏉熸棩鏈燂級
-hour
锛堝紑濮嬫棩鏈燂級鐨勫�间负
1
灏忔椂
锛?/p>
6
锛夊亣濡傚紑濮嬫棩鏈熶负
2012-09-09 10:00:00
Month
锛堢粨鏉熸棩鏈燂級
-month
锛堝紑濮嬫棩鏈燂級鐨勫�间负
1
涓湀
2.oracle sql
璇彞涓绠椾袱涓棩鏈熺浉宸殑璇硶
缁撴潫鏃ユ湡涓猴細
2013-5-27
11:20:47
寮�濮嬫棩鏈熶负锛?/p>
2013-4-23
11:24:13
锛?/p>
1
锛?/p>
Trunc
锛堝紑濮嬫椂闂达級
-trunc
锛堢粨鏉熸椂闂达級
鐨勫�间负
34
澶╋紙涓嶅姞鏃跺垎绉掕绠楋級
锛?/p>
2
锛?/p>
round(to_number
锛?/p>
cast(
缁撴潫鏃ユ湡
as date) - cast(
寮�濮嬫棩鏈?/p>
as date)))
鐨勫�?/p>
涓?/p>
35
澶╋紙鍔犱笂鏃跺垎绉掕绠?/p>
杩涜鍥涜垗浜斿叆锛?/p>
锛?/p>
3
锛?/p>
round(to_number
锛?/p>
cast(
缁撴潫鏃ユ湡
as
date) - cast(
寮�濮嬫棩鏈?/p>
as date))*24)
鐨?/p>
鍊间负
816
灏忔椂
锛堝姞涓婃椂鍒嗙璁＄畻
杩涜鍥涜垗浜斿叆锛?/p>
锛?/p>
4
锛?/p>
round(to_number
锛?/p>
cast(
缁撴潫鏃ユ湡
as
date) - cast(
寮�濮嬫棩鏈?/p>
as date))*24*60)
鐨勫�间负
48957
鍒嗛挓
锛堝姞涓婃椂鍒嗙璁＄畻
杩涜鍥涜垗浜斿叆锛?/p>
3.Sql
璇彞涓?/p>
db2
鍜?/p>
oracle
绫诲瀷杞崲璇硶
锛堜互
int
杞?/p>
char
涓轰緥锛?/p>
锛?/p>
PINT
涓?/p>
int
绫诲瀷锛?/p>
Db2
璇硶涓猴細
CHAR(PINT)
Oracle
璇硶涓猴細
CAST(PINT AS CHAR)
4.
鏌ヨ鍓?/p>
100
鏉℃暟鎹?/p>
Db2
鐨勮娉曚负锛?/p>
FETCH FIRST 100 ROWS
ONLY
Oracle
鐨勮娉曚负锛?/p>
where ROWNUM <= 100
锛堝湪鏁翠綋鏌ヨ鍑烘潵涔嬪悗鍐嶅姞杩欎釜鍒ゆ柇锛?/p>
5.
淇敼瀛楁绫诲瀷鐨勮剼鏈細
Db2
鐨勮娉曚负锛?/p>
ALTER table TABLENAME alter column COLUMN1set data type
VARCHAR(100);
Oracle
鐨勮娉曚负锛?/p>
ALTER TABLE TABLENAME MODIFY PRIVILEGE VARCHAR(100);
6.Oracle
涓妸鏃堕棿瀛楃涓茶浆鎹负鏃堕棿绫诲瀷鐨勮娉曚负锛?/p>
to_date('2013-04-29 15:50:54','yyyy-mm-dd hh24:mi:ss')
to_date(to_char(2013-04-29 15:50:54,'YYYY-mm-dd'),'YYYY-mm-dd')
7.
鎶婇潪绌哄垪鏀逛负鍙负绌哄垪
Db2
鐨勮娉曚负锛?/p>
ALTER TABLE TABLENAME ALTER COLUMN COLUMN1 DROP NOT NULL
Oracle
鐨勮娉曚负锛?/p>
Alter Table TABLENAME Modify COLUMN1 VarChar2(100) null