combining a date field with a time field 2 different formats - Oracle
Posted on 2013-11-20
Good Afternoon Experts,
I need some assistance on how to combine to fields together.
I have a field that is called surgery_start_date which a date field that shows as such:
8/25/2013 12:00:00 am
the other field called surgery_start_time is a vchar(5) fields with show the following
what I need is for to show up as
how can this be achieved? thanks in advance.