Oracle DATE to TIMESTAMP conversion

I am using oracle 9i currently we use date datatype in couple of fields.
what are the possible risks if we use TIMESTAMP datatype instead of DATE?


LVL 1
bondzoroAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
SujithConnect With a Mentor Data ArchitectCommented:
- Timestamp takes more space. Around 13 bytes, Compared to date - 7 bytes.
- If your application doesnt requires precision upto timestamp go for date
0
 
Stephen LappinConnect With a Mentor Senior TechnologistCommented:
Discoverer does not support TIMESTAMP.
There can be issues with timezone and daylight savings when comparing TIMESTAMPS.

If all you need it the time to the nearst second, I would recommend that yuu stick with DATE.
0
 
schwertnerCommented:
USE TIMESTAMP only if you need fraction of seconds.
There is no risk to use it. By default it stores dates with 6 digits after the decimal
points of the seconds.
TIMESTAMP with TIMEZONE is more complex and causes more errors
by different applications.
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.