How to tell hibernate to create Date instead of timestamp in DB?

Question

How can I tell hibernate that a Date should be created as a Date in postgres SQL database, and not as a timestamp? According to www.postgresql.org/docs/9.3/static/datatype-datetime.html Date should be possible, but how?

@Entity
class Test {
    private java.util.Date date;
}

becomes:

CREATE TABLE test
(date timestamp without time zone)

I think you should use java.sql.Date.

Marko Topolnik
– Marko Topolnik

2014-01-14 09:58:29 +00:00
Commented Jan 14, 2014 at 9:58 — Marko Topolnik
– Marko Topolnik, Commented Jan 14, 2014 at 9:58

kostja · Accepted Answer · 2014-01-14 10:04:52Z

1

Use the Temporal annotation:

@Temporal(TemporalType.DATE)
private Date date;

There are also TIME and TIMESTAMP TemporalTypes. TIMESTAMP is the default.

EDIT. You can also use one of the appropriate SQL types: java.sql.Date, java.sql.Time or java.sql.Timestamp.

The DB mapping is identical, whether you use java.util.Date with annotations or java.sql.* Using java.util.Date gives you a consistent interface regardless of the physical DB mapping while sql types may make your intent clearer.

edited Jan 14, 2014 at 10:04

answered Jan 14, 2014 at 9:59

kostja

61.8k51 gold badges186 silver badges227 bronze badges

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

3 Comments

whatswrong Over a year ago

It is not a solution, when timestamp is used in DB than hibernate will throw exception 'Found: timestamp, expected: date'.

kostja Over a year ago

The annotation will not fix your existing DDL, how is it supposed to do that? But during DDL generation from JPA entities, it will tell the JPA provider to create a DATE column, which was OPs requirement.

kostja Over a year ago

@whatswrong - IMHO you have misunderstood OP's requirement and the downvote is unwarranted. Your issue is a different one, you can post a separate question for it. If you think I have misunderstood OP's, please explain.

Collectives™ on Stack Overflow

How to tell hibernate to create Date instead of timestamp in DB?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related