SELECT TO_CHAR(TO_TIMESTAMP('2011-07-03 00:00:00.0'
,'YYYY-MM-DD HH24:MI:SSXFF')
,'YYYY-MM-DD')
,TO_DATE(TO_CHAR(TO_TIMESTAMP('2011-07-03 00:00:00.000'
,'YYYY-MM-DD HH24:MI:SSXFF')
,'YYYY-MM-DD')
,'YYYY-MM-DD')
FROM DUAL;
SELECT TO_CHAR(TO_TIMESTAMP('2011-07-03 00:00:00.0'
,'YYYY-MM-DD HH24:MI:SSXFF')
,'YYYY-MM-DD')
,TO_DATE(TO_CHAR(TO_TIMESTAMP('2011-07-03 00:00:00.000'
,'YYYY-MM-DD HH24:MI:SSXFF')
,'YYYY-MM-DD')
,'YYYY-MM-DD')
FROM DUAL;