insert into a data field

[BigLebowski]

Hi all,

I have to insert in a data field a value composed by a date and a time, that are
stored in another table
my problem is that the date is in a field (a data field) and the time in another (a
varchar2 field).
I've tried to concatenate as strings and convert with to_date but it gave me an
error.
How can I do?
Thank u very much.

[pragatiswain]

Hi all,

I have to insert in a data field a value composed by a date and a time, that are
stored in another table
my problem is that the date is in a field (a data field) and the time in another (a
varchar2 field).
I've tried to concatenate as strings and convert with to_date but it gave me an
error.
How can I do?
Thank u very much.

TO_DATE(DATE_FI ELD || TIME_FIELD, <DATE_FORMAT> )
DATE_FORMAT based on stored value in fields DATE_FIELD and TIME_FIELD
example : 'MM/DD/YYYYHH24MISS'

Hope this helps.