Re: Time conversions

From: Ed Prochak <edprochak_at_gmail.com>
Date: 21 Aug 2006 13:30:20 -0700
Message-ID: <1156192220.758637.276390@m79g2000cwm.googlegroups.com>

Please don't top post. Put your comments After the quoted text you are responding to.
(and trim appropriately)
rj wrote:
> Hey Dave,
>
> Thanx for the reply..
> you understand correctly, these values are entered by capturers who
> enter 90 mins instead of 01:30; and 26 hours instead of 1 day 2 hours
> etc..
> Any idea how i can change these without having to use substring and
> div/mod functions?
>
> Dave wrote:
> > rj wrote:
> > > Hi all,
> > >

[snip]

so what is so bad about using div() and mod() functions?

A simple design is to have a PL/SQL procedure that parses the data in the input temp table, assigns corrected values when loading the target table, and can also log success or error to a results table. Much greater control than straight SQL. The right tool makes each job easier.

HTH,
ed Received on Mon Aug 21 2006 - 15:30:20 CDT