mysql> desc my_uat.students;
+-----------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+----------------+
| student_id | int | NO | PRI | NULL | auto_increment |
| student_name | varchar(45) | NO | | NULL | |
| student_dob | datetime | NO | PRI | NULL | |
| student_address | varchar(45) | NO | | NULL | |
+-----------------+-------------+------+-----+---------+----------------+
As you can see in the above students table I have a filed student_dob declared as datetime, in this example, we will see how to insert a timestamp into this field using JDBC PreparedStatement,
Code Example:
String url ="jdbc:mysql://localhost:3306/my_db";
String userName="root";
String password ="root123";
String insertQuery ="insert into students values(?,?,?,?)";
Connection connection = DriverManager.getConnection(url,userName,password);
PreparedStatement preparedStatement = connection.prepareStatement(insertQuery);
preparedStatement.setString(1, null);
preparedStatement.setString(2, "Huge");
preparedStatement.setObject(3,Instant.now());
preparedStatement.setString(4, "Ohio");
int result = preparedStatement.executeUpdate();
As you can see we have made use of the Java 8 Instance (Date and Time API) class in order to insert a timestamp into the Database using PreparedStatement setObject method.

Have Questions? Post them here!
- Error: Can not find the tag library descriptor for
- Create a Database Table using JDBC PreparedStatement
- Java JDBC Select Multiple Records from table as List using PreparedStatement
- Java Jackson with Maven Example
- [fix] Java JDBC ConnectException: Connection refused
- Spring Boot: Transactions Management with JDBCTemplate Example
- Java Get Current Date for a Specific Time Zone
- What are the 8 Primitive Data Types in Java
- Java JDBC: Insert Java 8 LocalDate and Time using PreparedStatement
- Maven Eclipse (M2e) No archetypes currently available
- How to Sort a LinkedList in Java
- [Fatal Error] XML The markup in the document following the root element must be well-formed.
- Split a String in Java with Examples
- Struts 2 : There is no Action mapped for namespace [/] and action name [form] associated with context path [/proj]
- Truncate table using Java JDBC Example
- Java: Generate random numbers within a range
- Parse XML file in Java using DOM Parser
- How to get Client IP address using Java Code Example
- JDBCTemplate Querying Examples with Spring Boot 3
- [Java Threads] Should we extend Thread Class or implement Runnable interface
- String Boot + Redis - SET and GET String Commands Examples
- Setting up Spring Boot 3 + Maven + MySQL + JDBC Example
- Spring Boot: JdbcTemplate Update Query With Parameters Example
- Java Split String by Spaces
- Unbound classpath container: JRE System Library [JavaSE-1.7]
- How to Change Text Size for Android ActionBar - Android
- Git Revision Questions Before the Interview - Git
- How to install brew on macOS Ventura - MacOS
- How to create a Task List in SharePoint Online - SharePoint
- How to resolve Failed to create interpreter PyCharm Error - Python
- Enable spell check in Sublime Text (macOS) - MacOS
- Fix: Mac Screenshot opens in Mail Application - MacOS
- How to know the version of Teams installed - Teams