Re: Best way to clear stale data from very active audit tables

On Jul 24, 5:09 am, "bobdu..._at_gmail.com" <bobdu..._at_gmail.com> wrote:

>
> I don't want to use the SYSDATE as its a DATE and that is NOT going to
> translate well when the retention period is smaller, ie a few hours
> (not for this table but for others). What about if i used
> LOCALTIMESTAMP - i've done a quick scan and it might be because the
> CURRENT_TIMESTAMP is timezone specific, wheres the logdate is not. I
> can assume our app's clients all run in the same timezone (hopefully
> anyways!!!)... i'll give this a shot and i'll let you know what i
> find.

That sounds like a bad assumption!

jg

--
@home.com is bogus.
Wonder how Larry posts.  http://www.signonsandiego.com/uniontrib/20070721/news_1b21chats.html