When I do this in oracle 10g: select to_date(trunc(SOMEINPUTdATE)) from table1 where to_date(trunc(date_column_timestamp),\'MM/DD/YYYY\')
I have A anb 开发者_开发知识库B in String format A = 14/01/2007 B = 22:10:39 I try to insert date and time:
I\'m new to Oracle (I\'ve been using MySQL mainly 开发者_JS百科until now) so this might be a dumb question. But I have created this table (names are not english but ignore that, that is not important)
加载中,请稍侯......