Re: Need a "div" function for SQL*Plus

The data type is integer not DATE.
It came from another app (Remedy).
That is why I cannot deal with it using date arithmetic but want to find a "div" function.
The values in this field are like: 912402400 for Dec 1 1998 00:00:00 which is the seconds elapsed since Jan 1 1970.

In article <3696649B.46B61801_at_sybrandb.demon.nl>,   Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:
> This is a multi-part message in MIME format.
> --------------403B12D1D3C710C111868336
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Hi Chris
> The trunc and round function will also work on dates.
> Simply use trunc(date column,'dd-mm-yyyy') and gone are your seconds
> That should be all.
>
> hth,
> Sybrand Bakker, Oracle DBA
>
> chrisoc_at_ans.net wrote:
>
> > To work with some dates stored as long integers I would really
> > like a "div" function. I see "mod" but not "div".
> > I have to do a lot of "divving" by 86400, the number of
> > seconds in a day, to group records by day.
> >
> > Any leads will be appreciated.
> >
> > Chris O'Connor chrisoc_at_ans.net
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> --------------403B12D1D3C710C111868336
> Content-Type: text/x-vcard; charset=us-ascii;
> name="postbus.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Sybrand Bakker
> Content-Disposition: attachment;
> filename="postbus.vcf"
>
> begin:vcard
> n:Bakker;Sybrand
> x-mozilla-html:FALSE
> version:2.1
> email;internet:postbus_at_sybrandb.demon.nl
> x-mozilla-cpt:;0
> fn:Sybrand Bakker
> end:vcard
>
> --------------403B12D1D3C710C111868336--
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 19:42:55 CST