469,317 Members | 1,963 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

insert into a data field

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.
Dec 29 '06 #1
1 1651
pragatiswain
96 Expert
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_FIELD || TIME_FIELD, <DATE_FORMAT>)
DATE_FORMAT based on stored value in fields DATE_FIELD and TIME_FIELD
example : 'MM/DD/YYYYHH24MISS'

Hope this helps.
Dec 31 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by me | last post: by
20 posts views Thread by akej via SQLMonster.com | last post: by
6 posts views Thread by pk | last post: by
11 posts views Thread by Chris Fink | last post: by
3 posts views Thread by Hai Nguyen | last post: by
3 posts views Thread by MP | last post: by
3 posts views Thread by Mike Charney | last post: by
11 posts views Thread by Ted | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.