db2 '2012-03-30-02.24.55.203695' 字符转日期怎么转？？？？？？？？？？？？？？？？？

似乎有个叫date的函数

timestamp

貌似用STRING DELIMITED BY SIZE INTO 传一下估计能得到您想要的结果！
比方说 你先用ACCEPT接收一下DATE 和TIME 用两个变量接收
DATEYYYY PIC X(8).
TIMEHHHH PIC X(8).
DATETIME PIC X(22).
ACCEPT DATEYYYY FROM DATE YYYYMMDD
ACCEPT TIMEHHHH FROM TIME
STRING DATEYYYY(1:4) DELIMITED BY SIZE '-'
DATEYYYY(5:2) DELIMITED BY SIZE '-'
DATEYYYY(7:2) DELIMITED BY SIZE ' '
TIMEHHHH(1:2) DELIMITED BY SIZE ':'
TIMEHHHH(3:2) DELIMITED BY SIZE ':'
TIMEHHHH(5:2) DELIMITED BY SIZE ':'
TIMEHHHH(7:2) DELIMITED BY SIZE
INTO DATETIME.
显示结果应该是‘2013-12-12 23：44：45：22’
希望能帮到你

希望能帮到你