We're using 8.1.7, and I've discovered that the CURRENT_TIMESTAMP function is a new feature in 9i. The error was raised by an outside party who has obviously done some training with 9i and was trying to run the select on an 8i version and wanted to know why he was getting an error.
I've never used the function (of course!) and wasn't sure why it wouldn't work either, when I could see the syntax and function was valid from searching the net. However, none of the sites I went to seemed to specify that it's new with 9i....
Noel, the to_char option works like a charm in returning date and time in 8i.
Once again, thanks for responding so quickly!