Hello,
I am attempting to combine two separate columns into a single field of type DATE. The two columns are
- Case_Date (which is a DATE field)
- Case_Time (which is a VARCHAR2 field of length 5)
As an example, I have the following data (notice that the Case_Time field does NOT contain seconds):
| Case_Date | Case_Time |
|---|
| 3/9/2015 | 15:59 |
I have tried two things so far, without success:
- to_date(Case_Date || to_date(Case_Time, 'hh24:mi'), 'mm/dd/yyyy hh24:mi:ss') --this returns a ORA-01858 error (non-numeric where numeric was expected)
- Case_Date || to_date(Case_Time, 'hh24:mi') --this returns 09-MAR-1501-JUN-15 (because there is no date portion for Case_Time)
I have searched multiple forums, but haven't really found anything that addresses the issue of the two fields being of different data types. Any assistance would be appreciated. Thanks!