我晕，怎么的不出结果？？？？？？？？？

Question

to_char(vd_begin_call_date,'YYYYMMDDHH24')的值是多少？

Answer 1

单步调试vn_h2 老是0，
原来我是这么写的
select to_number(to_char(vd_begin_call_date,'HH24')) into vn_h1 from dual;
结果vn_h2都是０

Answer 2

没有问题呀！！！
SQL> select doctime from test1 where id=1;DOCTIME
----------------
2002-07-01 00:00
2002-05-01 10:12
2002-08-20 15:22
2002-07-01 00:00
2002-09-01 20:10Elapsed: 00:00:00.41
SQL> select substr(to_char(doctime,'YYYYMMDDHH24'),9,2) from test1 where id=1;SUBSTR(T
--------
00
10
15
00
20Elapsed: 00:00:00.40
SQL> select to_number(substr(to_char(doctime,'YYYYMMDDHH24'),9,2)) from test1 wh
ere id=1;TO_NUMBER(SUBSTR(TO_CHAR(DOCTIME,'YYYYMMDDHH24'),9,2))
------------------------------------------------------
                                                     0
                                                    10
                                                    15
                                                     0
                                                    20Elapsed: 00:00:00.50

Answer 3

to_char(vd_begin_call_date,'YYYYMMDDHH24')的值是多少？我看了一下，为  2002101800，可能问题就在这吧，可是为什么这样呢?
vd_begin_call_date是从表中取出的应该是有小时的啊

Answer 4

vd_begin_call_date是从表中取出的应该是有小时
你确认吗？