Timestamp/ Date error Java

Question

I have some problems with inserting a TimeStamp into the database(something is wrong with format. The db accepts dd.MM.yyyy). When I convert the Date to TimeStamp and then inserted it into the database, it fails. The format of TimeStamp is yyyy-MM-dd.

Do you have any ideas or suggestions?

possible duplicate stackoverflow.com/questions/8345023/…

Gatekeeper
– Gatekeeper

2013-03-14 13:01:04 +00:00
Commented Mar 14, 2013 at 13:01 — Gatekeeper
– Gatekeeper, Commented Mar 14, 2013 at 13:01

D.R. · Accepted Answer · 2013-03-14 13:00:33Z

1

If your DB really insists on dd.MM.yyyy and you have no option to use something like makedate(format, myDateInTheGivenFormat) then you have to do the reformatting within Java yourself.

Use SimpleDateFormat to reformat your date accordingly to the DB's needs.

answered Mar 14, 2013 at 13:00

D.R.

21.5k25 gold badges124 silver badges220 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

G.S · Accepted Answer · 2013-03-14 13:05:49Z

0

Please check the java.sql.Date, that can help you

answered Mar 14, 2013 at 13:05

G.S

11k8 gold badges43 silver badges56 bronze badges

Collectives™ on Stack Overflow

Timestamp/ Date error Java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related