Help : Converting Dates to Chars

I have an SQL statement which goes
  select * from <table>
I use this same statement to get the data from each table. The problem is when I encounter a Date field I only get the date and not the time, while I need both the date and the time data.

Eg : If I have a data 9-01-2000, 12:50 it only shows 9-01-2000. How do I change the settings so that oracle automatically shows 9-01-2000. 12:50.

And since I use it on different tables, I have no efficient way of knowing the name and the types of each field before hand. Thus I cannot just use to_char (D_SOMETHING, 'DD-MM.......').

Thanks ....

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 05:12:25 CDT