Path: utzoo!utgpu!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!mailrus!bbn!rochester!pt.cs.cmu.edu!andrew.cmu.edu!bg0l+
From: bg0l+@andrew.cmu.edu (Bruce E. Golightly)
Newsgroups: comp.databases
Subject: Re: Ingres ESQL/C & Unix date formats
Message-ID: <UXUSfdJ48k-0Q2xFEh@andrew.cmu.edu>
Date: 16 Nov 88 20:54:01 GMT
Organization: Carnegie Mellon
Lines: 22

You might try a slightly different set of operations. You are doing a
lot of conversions in the procedure as described which cannot help but
slow things down a lot. Try:

    select int4(interval('secs', date('1/1/70')))
outside of the program loop, storing it in a static os global item. Then,
the statement

    select int4(interval('secs', date_col))

Will extract the intercal in the row being manipulated at the time. Simple
arithmetic will then allow you to get the results you're looking for, I think.

Ingres substring operations are presently limited to left and right extractions.This, I agree, is a real pain. Having to do right(left(column_name, n),n) is
really annoying.

Hope this is of some help....

                                        Bruce
Gregory Bond, Burdett Buckeridge & Young Ltd, Melbourne, Australia
Internet: gnb@melba.bby.oz.au    non-MX: gnb%melba.bby.oz@uunet.uu.net
Uucp: {uunet,mnetor,pyramid,ucb-vision,ukc..}!munnari!melba.bby.oz!gnb