469,148 Members | 1,446 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

[WEIRD] Merge date and char

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?
Jul 19 '05 #1
1 2246
theDate+(hh24/24)+(mi/(24*60))
Should do it.
Jim

--
Replace part of the email address: ke************************@attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Mau Pastor" <ma*******@hotmail.com> wrote in message
news:65**************************@posting.google.c om...
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?

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Janick Bernet | last post: by
2 posts views Thread by William Wisnieski | last post: by
13 posts views Thread by ralphedge | last post: by
1 post views Thread by Mau Pastor | last post: by
2 posts views Thread by TamaThps | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.