MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Who can help me with this code ??
Posted by: Felix Geerinckx
Date: July 21, 2005 01:59AM

Alex Duin wrote:
> SELECT GMSHPRM00.HPRBEGDAT, GMSHPRM00.HPRENDDAT, GMSHPRM00.HPRADMNUM
> FROM NLGEMHKS.SASGMS.GMSHPRM00 GMSHPRM00
> WHERE GMSHPRM00.HPRBEGDAT AND GMSHPRM00.HPRENDDAT = CURDATE()
>
> This query doensn't work however, what can i do about my problem ? I get: operands not compatible.

Did you mean

WHERE GMSHPRM00.HPRBEGDAT = CURDATE() AND GMSHPRM00.HPRENDDAT = CURDATE()

--
felix
Please use BBCode to format your messages in this forum.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Who can help me with this code ??
Alex Duin
July 21, 2005 01:50AM
Re: Who can help me with this code ??
Felix Geerinckx
July 21, 2005 01:59AM


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.