Cast Function with Format option
Below is the query in Teradata
select
c_start_dt
|| ' '
|| CAST(c_start_tm AS INTEGER format '99:99:99' ) AS Date_Time
from table1;
I have to convert it to Oracle 10.2.0.1 .
my issue is I can not directly use 'format '99:99:99' is there any other way to do this..?
Expected Output :
Date_time
28/10/2011 13:19:50
28/10/2011 14:19:55
desc table1
call_start_dt date,
call_start_tm number(10)