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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 08 Jan 1999 21:03:39 +0100
Message-ID: <3696649B.46B61801@sybrandb.demon.nl>

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

Received on Fri Jan 08 1999 - 14:03:39 CST