Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dtmacd
-
Convert Timestamp fields to Date fields
The reason I thought I needed pl/sql was twofold... 1. I want to loop through all tables and columns - I have many of these & want to just convert all TIMESTAMPs int DATEs. 2. I thought the pl/sql would be faster.- dtmacd
- Post #5
- Forum: Oracle: All versions
-
Convert Timestamp fields to Date fields
Many thanks for the confirmation - any chance of a few pointers to the code requireed - I am a newbie to PL/SQL.- dtmacd
- Post #3
- Forum: Oracle: All versions
-
Convert Timestamp fields to Date fields
Hi, I have a 9i system with 9,000,000 records in - we have discovered all dates have been built as timestamp type. Really need to store Date type. Can someone advise on how best to do this - I am thinking about using PLSQL, & trying to loop through all table.columns checking for timestamp...- dtmacd
- Thread
- Replies: 5
- Forum: Oracle: All versions
