Re: Time series deletion performance

From: <peter_at_alum.wpi.edu>
Date: Fri, 12 Oct 2007 12:03:28 -0700
Message-ID: <1192215808.504946.169050@q3g2000prf.googlegroups.com>

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 Received on Fri Oct 12 2007 - 14:03:28 CDT