将oracle的Date转换为相应格式输出: select to_char(cn.createdate,'yyyy-mm-dd hh24:mi:ss') as createdate,cn.location_id from c_node cn where cn.name=#name#