How do I insert a value in a column where the type is datetime?

[To advertise Java(tm) Events here, contact joris@esus.com!]

Java™
by example!

	Login
	Login here Become a member only $14.95/year!

	New @ Esus.com
	In-house search engine for better results! Get updates with the esus.com newsletter!

Home

Browse Categories

Ask a Java Question

Help

For Java Tips & Tricks, subscribe to the esus.com newsletter!

Search Java Q&A, Links, API's: adv

Index:Java 2 Enterprise Edition (J2EE):JDBC

Printer-friendly version

How do I insert a value in a column where the type is datetime?

This example assumes that you have set up the table orders from this answer.

orders looks like this:

This code sample is only viewable to esus.com members Login or become a member!

The following example will populate this table with 4 rows, date is passed in as a java.util.Date and converted to a java.sql.Timestamp.

Main.java:

This code sample is only viewable to esus.com members Login or become a member!

This is the result:

This code sample is only viewable to esus.com members Login or become a member!

Further Information

Author of answer: Joris Van den Bogaert

Comments to this answer are only viewable by members. Login or become a member!