可以采用TO_DATE函数将'2012-05'转化为日期格式
TO_DATE('2012-05', 'YYYY-MM')
例子:
db2 => create table TEST2(c1 timestamp)
DB20000I The SQL command completed successfully.
db2 => insert into test2 values(to_Date('2012-05', 'YYYY-MM'))
DB20000I The SQL command completed successfully.
db2 => select * from test2
C1
--------------------------
2012-05-01-00.00.00.000000
1 record(s) selected.
第二个问题:
比较日期格式直接用< 或者>符号就可以比较日期格式了。
如下:
db2 => select * from test2 where c1 > current date
C1
--------------------------
0 record(s) selected.
db2 => select * from test2 where c1 <= current date
C1
--------------------------
2012-05-01-00.00.00.000000
1 record(s) selected.
温馨提示:答案为网友推荐,仅供参考