Re: Time series deletion performance

From: <fitzjarrell_at_cox.net>
Date: Fri, 12 Oct 2007 12:21:59 -0700
Message-ID: <1192216919.528522.230780@i13g2000prf.googlegroups.com>

On Oct 12, 2:03 pm, pe..._at_alum.wpi.edu wrote:
> I am storing timestamps as numbers, because that's how it was when I
> inherited the db. I hadn't considered that to be an issue.
>
> I'm unable to find the post you are referring to by Jonathan Lewis.
>
> On the issue you refer to with 00 coming after 59, I assume the
> problem you describe is with leading zeros being omitted. We are
> storing the number of milliseconds since 1970 and won't be susceptable
> to a leading zero issue for a couple hundred years.
>
> Also, we are running on Oracle 10g.
>
> Thanks,
> Peter

I wonder how you're generating those values.

David Fitzjarrell Received on Fri Oct 12 2007 - 14:21:59 CDT