timestamp 正常日期转换成时间戳格式

select cast(sysdate as timestamp) "DATE" from dual

select to_timestamp(to_date(sysdate, 'yyyy-mm-dd')) from dual

select to_timestamp('2008-11-17 00:31:35', 'YYYY-MM-DD HH24:MI:SS:FF') from dual

ctl抽数 “to_timestamp(:<字段名>, 'YYYY-MM-DD HH24:MI:SS:FF')”