Oracle插入timestamp類型資料,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 stubPreparedStatement 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
出處:http://blog.csdn.net/itmyhome1990/article/details/41776721