Oracle插入timestamp类型数据详解数据库

表结构：

create table TEST( 
  ID       INTEGER, 
  BIRTHDAY TIMESTAMP 
);

使用JDBC将日期插入到TIMESTAMP类型字段

import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.PreparedStatement; 
import java.sql.SQLException; 
import java.text.SimpleDateFormat; 
import java.util.Date; 
 
public class Test { 
	 
	static { 
		try { 
			Class.forName("oracle.jdbc.driver.OracleDriver"); 
		} catch (ClassNotFoundException e) { 
			e.printStackTrace(); 
		} 
	} 
 
	/** 
	 * 获得Connection 
	 *  
	 * @return 
	 */ 
	public static Connection getConnection() { 
		Connection conn = null; 
		try { 
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/orcl", "root", "root"); 
		} catch (SQLException e) { 
			e.printStackTrace(); 
		} 
		return conn; 
	} 
 
	public static void main(String[] args) throws SQLException { 
		// TODO Auto-generated method stub 
		PreparedStatement pst = null; 
		Connection conn = getConnection(); 
		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
		String myDate = df.format(new Date()); //当前时间 
		String sql = "insert into test(id,birthday) values('1',to_timestamp('" + myDate + "','yyyy-mm-dd hh24:mi:ss'))"; 
		pst = conn.prepareStatement(sql); 
		 
		pst.executeUpdate(); 
		// 省略IO流close 
	} 
 
}

使用to_timestamp将字符型转成timestamp

作者：itmyhome

出处：IT虾米网