Re: Problem with user variables
Posted by:
Jay Pipes
Date: November 07, 2005 02:19PM
AFAIK, the reason you are having the issue is because the DATE_ADD function and specifically the INTERVAL clause expects a numeric argument and a *keyword* indicating the interval length. In your case, you are passing a string instead.
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com
Subject
Views
Written By
Posted
2743
November 07, 2005 01:03PM
Re: Problem with user variables
1863
November 07, 2005 02:19PM
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.