Date function

Guys!

I have a column in the table declared as DATE. When I do a select from the column, SQL*PLUS always returns the date component. I want to see the time component always along with the date component and I don't want to use the to_char() function. Can something be set in the environment. Needless to say the need is driven out of laziness. I am using Oracle 7.3 on Oracle NT 4.0.

Thanks.

--
Vijay Raghavacharian
vragha_at_ctp.com
voice: 650-372-6246
fax: 650-372-6200

Cambridge Technology Partners (415-574-3710)
1300 South El Camino Real, Suite 600
San Mateo, CA 94402
http://www.ctp.com