Click here to Skip to main content
15,900,517 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
SQL
DELIMITER $$

DROP PROCEDURE IF EXISTS `datepaty`.`datepart` $$
CREATE PROCEDURE `datepaty`.`datepart` ()
BEGIN
 declare week1 int
 SELECT week('98-04-01');
END $$

DELIMITER ;



i get the following error
SQL
Script line: 4  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT week('98-04-01');
END' at line 4

thank you in advance
Posted
Updated 10-May-12 3:41am
v2

What about
SELECT week('1998-04-01');?
 
Share this answer
 
yeah thats the mistake
thank you
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900