对2012/1/14 10:46:03进行日期格式转换
例:
Java:
SimpleDateFormat sdfx ;
SimpleDateFormat sdfh ;
String operation_time="";
String time="";
time="2012/1/14 10:46:03".split(" ")[0];
sdfx = new SimpleDateFormat("yyyy/MM/dd");
sdfh = new SimpleDateFormat("yyyyMMdd");
operation_time = sdfh.format(sdfx.parse(time));
System.out.println(operation_time );
ORACLE:
SELECT to_char(to_date('2012/1/14 10:35:23','yyyy/mm/dd hh24:mi:ss'),'yyyymmdd') FROM dual;