[Monetdb-developers] About data type "interval"

eric6251 eric_6251 at yahoo.com.cn
Fri Dec 22 10:31:06 CET 2006


Dear Sir/Madam:
   I came across a problem when running a SQL statement:
  select l_linestatus
  from lineitem
  where shipdate <= date '1998-12-01' - interval '1 day'   //I want to
search the records whose shipdate is prior to the day before Dec. 1998
  
  But MonetDB returned me with the error message: syntax error, unexpected
SCOLON in: "select ...," the whole SQL sentence above,
  What's wrong? 
  Thank you!

eric
  
-- 
View this message in context: http://www.nabble.com/About-data-type-%22interval%22-tf2869866.html#a8021165
Sent from the monetdb-developers mailing list archive at Nabble.com.





More information about the developers-list mailing list