to_date,to_char转化问题？谢谢

11 |

如果有时分秒
where TO_CHAR(DT,'YYYY-MM-DD') = '1111-11-11'
如何转化成
where dt = to_date(......

千问 | 2007-9-26 18:42:10 | 显示全部楼层

where dt=to_date('1111-11-11','yyyy-mm-dd');

千问 | 2007-9-26 18:42:10 | 显示全部楼层

where dt between to_date('1111-11-11 00:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('1111-11-11 23:59:59','yyyy-mm-dd hh24:mi:ss');

千问 | 2007-9-26 18:42:10 | 显示全部楼层

where dt=to_date('1111-11-11 00:00:00','yyyy-mm-dd hh24:mi:ss')

千问 | 2007-9-26 18:42:10 | 显示全部楼层

文档

主题	0 回帖	4882万积分

Rank: 8 Rank: 8

热门排行