db2日期格式转换

https://blog.csdn.net/f7anty/article/details/44857557

1.select date(trim(char('2009-09-01 '))),time(trim(char('12:23:34 '))),timestamp(trim(char('2009-02-26-14.28.40.234000')))
from sysibm.dual

2.select char(current date),char(current time),char(current timestamp) from sysibm.dual

3.select to_char(current timestamp,'yyyy-mm-dd hh24:mi:ss') from sysibm.dual

4.select to_date('2009-01-01 12:23:45','yyyy-mm-dd hh24:mi:ss') from sysibm.dual