Re: Adding date fields
From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: Fri, 10 Jul 1998 15:54:07 GMT
Message-ID: <01bdac1a$fa2fb680$049a0580_at_mcb>
Date: Fri, 10 Jul 1998 15:54:07 GMT
Message-ID: <01bdac1a$fa2fb680$049a0580_at_mcb>
Try this:
select n+to_number(to_char(d,'SSSSS'))
from my_table;
-- Matt Brennan SQL*Tools Specialist GERS Retail Systems 9725-C Scranton Road San Diego, California 92121 1-800-854-2263 mbrennan_at_gers.com (Original email address is spam-blocked.) Delfosse Vincent <vdelfosse_at_skynet.be> wrote in article <6o4eih$5tq$1_at_news1.skynet.be>...Received on Fri Jul 10 1998 - 17:54:07 CEST
> Hello,
>
> I've a problem with oracle 6 on unix.
>
> I've a table with 2 fields:
> n number
> d date
>
> The "n" field represent a number of seconds.
> I want to add the 2 fields. Oracle 6 don't allow to add two date fields.
>
> Any idea ?
>
> Thanks.
>