Solved

Oracle DATE to TIMESTAMP conversion

Posted on 2006-11-13
5
2,189 Views
Last Modified: 2012-06-22
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?


0
Comment
Question by:bondzoro
5 Comments
 
LVL 27

Accepted Solution

by:
sujith80 earned 25 total points
ID: 17929497
- Timestamp takes more space. Around 13 bytes, Compared to date - 7 bytes.
- If your application doesnt requires precision upto timestamp go for date
0
 
LVL 7

Assisted Solution

by:lappins
lappins earned 25 total points
ID: 17929584
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
 
LVL 47

Expert Comment

by:schwertner
ID: 17929659
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
 
LVL 1

Expert Comment

by:Computer101
ID: 20296227
Forced accept.

Computer101
EE Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now