不能直接赋值,如下:
t_planstartdate date := '2013-01-31 00:00:00';
或者
select to_date('2013-01-31 00:00:00','yyyy-mm-dd 24hh:mi:ss') into t_planstartdate from dual ;
必须像下面这样赋值,才可以:
select to_date('2013-01-31 00:00:00','YYYY-MM-DD HH24:MI:SS') into t_planstartdate from dual ;