[Monetdb-developers] About data type "interval"

Niels Nes Niels.Nes at cwi.nl
Fri Dec 22 14:12:08 CET 2006


On Fri, Dec 22, 2006 at 01:31:06AM -0800, eric6251 wrote:
> 
> 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? 

Eric

Thanks for using MonetDB/SQL.
The error message is indeed nog very clear.
I think your interval maybe the problem
Could you try with

interval '1' day

Niels
>   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.
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the developers-list mailing list