利用SimpleDateFormat类 // Format the current time.
SimpleDateFormat formatter
= new SimpleDateFormat ("yyyy.MM.dd G 'at' hh:mm:ss a zzz");
Date currentTime_1 = new Date();
String dateString = formatter.format(currentTime_1);
// Parse the previous string back into a Date.
ParsePosition pos = new ParsePosition(0);
Date currentTime_2 = formatter.parse(dateString, pos);
SimpleDateFormat formatter
= new SimpleDateFormat ("yyyy.MM.dd G 'at' hh:mm:ss a zzz");
Date currentTime_1 = new Date();
String dateString = formatter.format(currentTime_1);
// Parse the previous string back into a Date.
ParsePosition pos = new ParsePosition(0);
Date currentTime_2 = formatter.parse(dateString, pos);
也可以用FormatDate对象
当然直接用Date对象,取得getDay(),getYear(),getMonth()自己组成也可以 :)
insert into t_news(DateAndTime) values(to_date('"+DateAndTime+"','yyyy-mm-dd hh24:mi:ss'));
得到的是
insert into t_news(DateAndTime,NewsId,TypeId) values(to_date('Fri Mar 15 14:43:56 CST 2002','yyyy-mm-dd hh24:mi:ss'),'12',1)
String sql = "into t_news(DateAndTime) values( ?)";PreparedStatement pstmt = conn.preparedStatement(sql);
pstmt.setString(1, date);return pstmt.executeUpdate();
里面有时间,语言,数据格式等转换
不知道oracle里日期型字段如何赋值
如果与sqlserver差不多的话
可以定义一个java的method用以转换格式
偶提供的代码to_date即是如此主要使用java.text.SimpleDateFormat类,参见API