Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Concatenate date and time that are stored in two different date columns

Krishna Devi VinayakaNov 11 2014 — edited Nov 11 2014

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.

This post has been answered by Frank Kulash on Nov 11 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 9 2014
Added on Nov 11 2014
13 comments
11,366 views