Database Administration (MOSC)

MOSC Banner

We have a table with column period defined as timestamp datatype to store date and time, when day l

edited Dec 14, 2012 2:19PM in Database Administration (MOSC) 1 commentAnswered
We have a table  with column period defined as timestamp datatype to store date and time, when day light saving  sets back one hour, we have duplicated the times , and the period is a unique key.  how to avoid this issue?
Would changing timestamp datatype to timestamp with time zone address this issue?

Also how should java  insert to the table?
The java code we have right now is the following

quickviewInsertStatement.setTimestamp(1, new Timestamp(start.getTime()));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center