Java Entities Dates fields and Oracle TIMESTAMP data types

Question

In my entities classes I use to define the temporal fields as follows:

    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "START_DATE")
    private Date start;

In my oracle DB the columns mapped by those fields are of type TIMESTAMP.

What are the implications of this configurations:
Are my dates implicitily UTC dates ?
Does it mean I have to be careful on handling by myself Daylight saving time issues ?

Lukas Eder · Accepted Answer · 2017-01-22 17:01:40Z

2

The JPA TemporalType.TIMESTAMP corresponds to the JDBC java.sql.Timestamp type, which in turn corresponds to Oracle's (and the SQL standard) TIMESTAMP [ WITHOUT TIME ZONE ] type. While JDBC 4.2 (Java 8) added support also for OffsetDateTime, Java EE 7's TemporalType is not there yet.

This means that your values do not have any time zone attached to them, the semantics of the timestamp is that of the "local time zone", whatever that is configured to be. Of course, you have to watch out for potentially different server (database) and client (machine running your Java application) "local time zones"!

You can achieve the desired behaviour if you are sure that client and server time zones are set to UTC.

edited Jan 22, 2017 at 17:01

answered Jan 22, 2017 at 16:43

Lukas Eder

223k138 gold badges731 silver badges1.6k bronze badges

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

10 Comments

GionJh Over a year ago

thanks! please can you elaborate a little bit more on what you said about "the semantics is that of the "local time zone""

GionJh Over a year ago

When you say client and server you mean Application server and RDBMS?

Lukas Eder Over a year ago

@GionJh: Edited to make this more clear. I strongly suggest you read up the documentation about this.

GionJh Over a year ago

Yeah thanks I'm a little bit confused also because I thought java.util.Date only refers to UTC timezone and not your system time zone, is it right ?

GionJh Over a year ago

posted it ;) stackoverflow.com/questions/41803879/…

|

Collectives™ on Stack Overflow

Java Entities Dates fields and Oracle TIMESTAMP data types

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related