Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> migrating a date and varchar field into 1 date field
I'm migrating some old data from a progress database. I was given a data extract that was sql loaded into Oracle. I have two columns
date_col (has the proper month,day,year) and is a date type
time_col(has the proper time in minutes, seconds, etc...) and is a varchar field
anyway to dummy it up so I can get both of these into the same column? the date_col has an incorrect time of day.
![]() |
![]() |