Trying to figure out how to create this procedure

Question

I can't seem to figure this out and I've been at it for sometime now any help would be great thank you.

I have to prepare a simple procedure accepting one parameter, a date value, and using date addition functions in SQL (MySql if possible) return the parameter value minus 1 day

CREATE PROCEDURE get_date
IS 
BEGIN
DATE_ADD(date,INTERVAL expr type)
END;
/
EXEC get_date

This was all I could come up with so far. Any help would be greatly appreciated.

That question is not just about select statement (ie, computing minus one day); I need help with a SQL procedure.

Possible duplicate of [How to subtract 3 hours from a datetime using SQL?](http://stackoverflow.com/questions/6020162/how-to-subtract-3-hours-from-a-datetime-using-sql) — Juan Carlos Oropeza, Oct 27 '15 at 15:11
Thank you. I looked at it maybe the answer is staring me in the face. I am not sure. So is the query rite. — James Martiuk, Oct 27 '15 at 15:48

score 1 · Accepted Answer · answered Oct 27 '15 at 16:01

1

Maybe just create a function

CREATE FUNCTION simplefunction (s datetime)
   RETURNS datetime DETERMINISTIC
   RETURN DATE_SUB(s, INTERVAL 1 DAY);

SELECT simplefunction (anydate);

answered Oct 27 '15 at 16:01

Juan Carlos Oropeza

47,252
12
78
118

Thank you i will give that a shot instead. – James Martiuk Oct 27 '15 at 16:16
I'm really sorry about that i completely forgot. Also it does work that way i appreciate all your help. – James Martiuk Oct 27 '15 at 18:35

Trying to figure out how to create this procedure

1 Answers1