废话...............,不知道就别说嘛....................我也知道要转换,要符合规范,要是我知道如何具体写,我发贴干嘛???求人不如求己,自己解决: select to_char(create_date, 'MM/DD/YYYY HH24:MI:SS') before from sb where id = 5;select * from sb where create_date = to_date('10/21/2003 18:47:23', 'MM/DD/YYYY HH24:MI:SS');
select to_char(create_date, 'MM/DD/YYYY HH24:MI:SS') before from sb where id = 5;select * from sb where create_date = to_date('10/21/2003 18:47:23', 'MM/DD/YYYY HH24:MI:SS');