Concatenate

Hi

i have a test table in oracle. The two columns are START_DATE and START_TIME.
START_DATE is stored as 16/03/2006 and START_TIME as 55000.

I need to concatenate the start_date and start_time and i need to stored it as
START_DATE_TIME but in timestamp format dd/mm/yyyy hh:mm:ss .

plz help..

thanks in advance. Received on Thu Mar 16 2006 - 07:02:52 CST