sql - Alternative to 'interval' date syntax for IBM solidDB -


A research project, I'm going to run, so I am using IBM's solid DB some test questions Could. I'm using a dataset is dataset TPC-H, so the use of this question seems logical option 8 to 19 questions, however, use the SQL-92 date interval syntax: 

  select as l_returnflag, l_linestatus, yoga as sum_qty (l_quantity), yoga (l_extendedprice) sum_base_price, yoga (l_extendedprice * (1 - l_discount)) as sum_disc_price, yoga (l_extendedprice * (1 - l_discount ) * (1 + l_tax)) avg_price, average (l_discount as avg_qty, average (l_extendedprice as sum_charge, average (l_quantity))) as as avg_disc, Inti (*) as count_order line item where l_shipdate & lt; = Date '1998/12/01' - Interval ': 1' day (3) group by l_returnflag, order by l_returnflag l_linestatus, l_linestatus;   
 It: 1 is filled by the query generator as a number. Interval does not support keywords according to solid, solid DB.  
 TPC-H for providing access to the query template with the benchmark, reduced me days to a date and time that such a type requiring alternative syntax. There is nothing more to do this, so I am out of ideas at this time.   
 
 
 I am not an expert on solid dB, but this syntax in your links by ..  SELECT NAME, {fn TIMESTAMPADD (SQL_TSI_YEAR, 1, HIRE_DATE)} employees   
 Try putting {FN} around your function call?

Comments

Post a Comment