For a research project, I'm using IBM's solidDB to run some test queries on. The dataset I'm using is the TPC-H dataset, so using the queries that come with it seems like a logical choice. 8 out the 19 queries, however, use SQL-92's date interval syntax:

```
select
    l_returnflag,
    l_linestatus,
    sum(l_quantity) as sum_qty,
    sum(l_extendedprice) as sum_base_price,
    sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
    sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
    avg(l_quantity) as avg_qty,
    avg(l_extendedprice) as avg_price,
    avg(l_discount) as avg_disc,
    count(*) as count_order
from
    lineitem
where
    l_shipdate <= date '1998-12-01' - interval ':1' day (3)
group by
    l_returnflag,
    l_linestatus
order by
    l_returnflag,
    l_linestatus;

```

The :1 in there is filled by the query generator as a number. According to the solid [IBM solidDB SQL Guide](http://www.google.com/url?sa=t&source=web&cd=2&sqi=2&ved=0CBkQFjAB&url=ftp%3A%2F%2Fftp.software.ibm.com%2Fsoftware%2Fdata%2Fsoliddb%2Finfo%2F6.5%2Fman%2FSQLGuide.pdf&rct=j&q=ibm%20soliddb%20sql%20guide&ei=mdyATb-JOY2LhQepmsWxBw&usg=AFQjCNHEHJFUjr6EFxEfOnAvmzlN7RtwPQ&cad=rja), solidDB doesn't support the interval keyword. 

In order to use the query templates provided with the TPC-H benchmark, I need some sort of alternative syntax to use as for substracting days from a date and the like. The [TIMESTAMPADD](http://publib.boulder.ibm.com/infocenter/soliddb/v6r5/topic/com.ibm.swg.im.soliddb.programmer.doc/doc/s0005327.time.and.date.functions.html) didn't seem to do much either, so I'm out of ideas at the moment.