How to map MySQL Timestamp field in Spring JAVA(JPA/Hibernate)

Question

I am having trouble finding how to map different type of fields for different DBs in a Spring Boot Application. Primarily, I would like to know how to map the MySQL Timestamp but it would be great if I can also find a link to the collection of mappings for every datatype in different DBs.

Answer 1

The list of standard basic types you can find here.

1. You can map TIMESTAMP to the following Java 8 types:

java.time.Instant, java.time.LocalDateTime, java.time.OffsetDateTime and java.time.ZonedDateTime.

2. You can also use outdated java.util.Date (see this):

@Column(name = "`timestamp`")
@Temporal(TemporalType.TIMESTAMP)
private Date timestamp;

But the first approach is much more preferable.