On Sat, Jun 17, 2006 at 13:08:20 -0700,
Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> I am working with the date_trunc() function with great success especially in
> the group by clause
> for aggregates.
>
> However, it is limited to returning "WHOLE" time units. i.e. years, months,
> days,
> > Are there any functions similar to date_trunc that can return variable
> > increments i.e.:
> >
> > 5, 10, or 15 minutes increments,
> > 3, 4, 6 hour increments,
> > 1, 2 weekly increments,
> You might be able to extract the time since the epoch and divide it by the
> appropiate number of se
Looks good but you really shoud put your stmt.close() and conn.close() in a finally block so even if there is an error everything gets cleaned up properly. That syntax is for Java but the principle is the same for any programming language - always make sure you clean up your connections no matter
