Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Time conversions

Re: Time conversions

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 21 Aug 2006 14:03:14 -0700
Message-ID: <1156194193.900658@bubbleator.drizzle.com>


Ed Prochak wrote:
> 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?
>
>
> HTH,
> ed

Well for one thing one of them doesn't exist in Oracle TTBOMK.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 21 2006 - 16:03:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US