What is the standard way to keep timestamp in Java and MySQL

Question

Should I handle timestamp as String in java or as long? How to convert timestamps from Java to MySQL? Is there any standard pattern followed?

use http://stackoverflow.com/questions/17808875/to-store-a-date-in-mysql-as-dd-mm-yyyy-format-through-netbeans-but-mysql-genera — HackerGK, Dec 10 '13 at 09:20

score 1 · Accepted Answer · edited May 23 '17 at 10:32

First of all, to persist a java.util.Date into a database in Java, you will have to convert it to java.sql.Date. The fortunate thing about JDBC SQL Date is that it's a subclass of Java Date.

Therefore, to create a java.sql.Date from java.util.Date, you will have to do this:

DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
Date myDate = formatter.parse(date);
java.sql.Date sqlDate = new java.sql.Date(myDate.getTime());

db.insert_date(sqlDate);

Make sure that db.insert_date accepts only java.sql.Date.

also read about java.util.Date vs java.sql.Date

SpringLearner · Answer 2 · 2013-12-18T07:18:37.273

0

Should I handle timestamp as String in java or as long? you should not because timestamp class is already present in sql package

How to convert timestamps from Java to MySQL? use setTimestamp() and for example see this example

edited Dec 18 '13 at 07:18

answered Dec 10 '13 at 09:20

SpringLearner

13,738
20
78
116

score 0 · Answer 3 · answered Dec 10 '13 at 09:22

As such no standard pattern is followed. There is a method called setTimestamp available in PreparedStatement. You can use it to set timestamp values. More info is available at - http://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#setTimestamp(int, java.sql.Timestamp) and http://alvinalexander.com/java/java-timestamp-example-current-time-now

What is the standard way to keep timestamp in Java and MySQL

3 Answers3