Home -> Usenet -> comp.databases.oracle -> [WEIRD] Merge date and char

[WEIRD] Merge date and char

From: Mau Pastor <maupastor_at_hotmail.com>
Date: 4 Oct 2003 01:28:15 -0700
Message-ID: <6575a8ed.0310040028.5e1d9523_at_posting.google.com> 






I am creating a view on a table that has the date information split in
two columns: a DATE column and a char column. The char column holds
the HH24:MI information. Please don't ask me why this is like this,
it's a very old database converted from a different DBMS.



I need to get this information into a single DATE column. Ny best shot
so far was to try get the total number of minutes with substr and add
them to the date, but I could not get it right.



Can anyone show me an example?
Received on Sat Oct 04 2003 - 10:28:15 CEST












Original text of this message