format date with Oracle Dynamic SQL

Hi all,

when i set a date field's type (12) to VARCHAR2 or STRING, I get the date (mm/dd/yyyy) correct, but I can never get the time which is always set to 00:00:00 even if i increase the buffer size? Is there anyway to force pro*c to format correctly without using to_char because with to_char i lose the ability to keep track of correct data type.

Thanks Received on Tue Mar 01 2005 - 11:52:41 CST