File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How to insert automatic timestamp? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to insert automatic timestamp?" Watch "How to insert automatic timestamp?" New topic

How to insert automatic timestamp?

Mike Dafel

Joined: Jul 12, 2001
Posts: 10
I want to insert an automatic timestamp(consisting of date & time) in my table using JDBC. I am writing servlets to poulate my tables. Could anybody provide a code snippet to include in my servlets. Please help as I am confused between java.util.Date and java.sql.Date. I don't know how to use them as I couldn't find an example anywhere.
Thanks in advance.
Napa Sreedhar
Ranch Hand

Joined: Jan 29, 2002
Posts: 62
If you have a Date column in your database table then construct the query as
String stmt = "insert in to my_table "
+ " values(?, ?, ... , SYSDATE)";
If you want to append the time stamp to some VARCHAR2 column, then obtain a String using java.util.Date and insert the column as a String.
Hope this helps.
I agree. Here's the link:
subject: How to insert automatic timestamp?
It's not a secret anymore!