1.alter session set nls_date_language='american'; 2.SELECT to_timestamp('Fri 19Mar10 10:20:42','DY DDMONYY HH:MI:SS') from dual;
1、可能先要修改日期的语言格式(如果是中文) alter session set nls_date_language=american 2、使用日期类的转换函数(如楼上),下面是to_date SELECT to_date('Fri 19Mar10 10:20:42','DY DDMONYY HH:MI:SS') from dual;
return Timestamp.valueOf(date + " 00:00:00");
}
2.SELECT to_timestamp('Fri 19Mar10 10:20:42','DY DDMONYY HH:MI:SS') from dual;
alter session set nls_date_language=american
2、使用日期类的转换函数(如楼上),下面是to_date
SELECT to_date('Fri 19Mar10 10:20:42','DY DDMONYY HH:MI:SS') from dual;