select to_date(createddate,'YYYY-MM-DD')from n_url_test@H_404_16@
select to_date(createddate,'YYYY-MM-DD')from n_url_test
修改成下面就可以了
(createddate::text) from n_url_test;;
(createddate::text) from n_url_test;
