Re: [WEIRD] Merge date and char
From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Sat, 04 Oct 2003 15:41:20 GMT
Message-ID: <ASBfb.405282$2x.135801_at_rwcrnsc52.ops.asp.att.net>
Date: Sat, 04 Oct 2003 15:41:20 GMT
Message-ID: <ASBfb.405282$2x.135801_at_rwcrnsc52.ops.asp.att.net>
theDate+(hh24/24)+(mi/(24*60))
Should do it.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Mau Pastor" <maupastor_at_hotmail.com> wrote in message news:6575a8ed.0310040028.5e1d9523_at_posting.google.com...Received on Sat Oct 04 2003 - 17:41:20 CEST
> 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?