Skip navigation links

MySQL Forums :: Newbie :: Equivalent date interval query does not compile


Advanced Search

Re: Equivalent date interval query does not compile
Posted by: Rick James ()
Date: September 08, 2011 08:51PM

What is the datatype of image_indexing_date?

Possibly this change will work:
where cast(image_indexing_date as date) >= current_date - interval ? day
-->
where image_indexing_date >= current_date - interval ? day

INTERVAL can only be used after +/-

Options: ReplyQuote


Subject Written By Posted
Equivalent date interval query does not compile Dmitry Katsubo 09/05/2011 06:46AM
Re: Equivalent date interval query does not compile Peter Brawley 09/05/2011 10:44AM
Re: Equivalent date interval query does not compile Dmitry Katsubo 09/06/2011 04:17AM
Re: Equivalent date interval query does not compile Peter Brawley 09/06/2011 11:10AM
Re: Equivalent date interval query does not compile Rick James 09/08/2011 08:51PM
Re: Equivalent date interval query does not compile Dmitry Katsubo 09/09/2011 05:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.