Hi,
I have to select two date columns from two different tables one with date and another with time .
I want to concatenate these two columns and format the result as dd/mm/yyyy hh24:mi
But I get error invalid number
For example
create table datetime as
(select to_date('21/01/2014','dd/mm/yyyy') as dt,to_date('08:00','hh24:mi') as tm from dual
)
select to_char(dt||tm,'dd/mm/yyyy hh24:mi') from datetime
I use oracle 10g
Please help.