« Staff Development, Thursday, October 19, 2006 | Main | Oracle Dates and Times -- Success! »
October 20, 2006
Oracle Dates
When I first configured my Calendar table for the Scheduler project, I ran into difficulties with the date columns. This was almost entirely due to my lack of experience. In a class I took a couple of years ago and in my reading about Oracle the past few years, I have learned that the subject of dates and times is not to be taken lightly. I am now gaining valuable, practical experience with Oracle dates and times. After first running into difficulties, I decided to just use varchar2 values for these table columns thinking that I would convert these items to dates later and make everything right with the world. I decided that this week would be a good opportunity to take care of this conversion. I took care of the table columns and I think I almost have my PL/SQL package working properly, but I'm still dealing with some run-time errors. My approach, for the moment, is to use Oracle's trim and to_char functions to use the date and time values for comparison and for output through htp.print. I expect to have everything working properly by early next week. I wouldn't have even considered this task before making backup copies of my table and appropriate packages first. When I get things working the way I want, I'll write a blog entry to celebrate!
Posted by goodeld at October 20, 2006 3:51 PM