[PHP] Stored Proc - Date not inserting into the Record

I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE definer=`do...@`` PROCEDURE `Insert_OHC_Sun`(theDate DATE,theDateRaw INT) BEGIN INSERT INTO Office_Hours_Cuttoff (ohc_Date,ohc_Date_Raw,Office_Status) VALUES (theDate,theDateRaw,Closed);

Re: [PHP] Stored Proc - Date not inserting into the Record

Change the input argument type as a varchar instead of date Ex: CREATE definer=`do...@`` PROCEDURE `Insert_OHC_Sun`(theDate VARCHAR(50),theDateRaw INT) surly it will work - Peter Don Wieland wrote: I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE

Re: [PHP] Stored Proc - Date not inserting into the Record

FYI Please Pass your input within quotes $db-query(CALL Insert_OHC_Sun(*'*{$nDate}*'*,{$cDate})); surly it will work - Peter Don Wieland wrote: I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE definer=`do...@`` PROCEDURE `Insert_OHC_Sun`(theDate