|
1、查询日期,用to_char转换
select C.CREATEDATE,TO_CHAR(C.CREATEDATE,'YYYY/MM/DD HH24:MI:SS')
from 表 c
where id=22156542
CREATEDATE TO_CHAR(C.CREATEDATE,'YYYY/MM/DDHH24:MI:SS')
2013/7/1 0:47:47.808 0000/00/00 00:00:00
2、转换两次报错:
select C.CREATEDATE,to_date(TO_CHAR(C.CREATEDATE))
from 表 c
where id=22156542
ORA-01847 day of month must be between 1 and last day of month
3、日期做计算
select C.CREATEDATE,to_date(TO_CHAR(C.CREATEDATE)),C.CREATEDATE+1,TO_CHAR(C.CREATEDATE+1,'YYYY/MM/DD HH24:MI:SS')
from 表 c
where id=22156542
CREATEDATE TO_CHAR(C.CREATEDATE,'YYYY/MM/DDHH24:MI:SS') C.CREATEDATE+1 TO_CHAR(C.CREATEDATE+1,'YYYY/MM/DDHH24:MI:SS')
2013/7/1 0:47:47.808 0000/00/00 00:00:00 2013/7/2 0:00:09.000 0000/00/00 00:00:00
求救,怎么数据变成这样了
或许是我的问题没描述清楚,
这个主要的问题是,一个表的CREATEDATE字段是date类型,但是用to_char转换后显示出来的全是0000/00/00 00:00:00,而且只有这一个表的部分数据是这样,其他数据都没问题。
|
|