Subject | Stored procedure & date function |
---|---|
Author | Datatal AB - Gauffin, Jonas |
Post date | 2003-11-01T11:30:42Z |
Hello
I get a char(10), called dep_date, as input to a stored procedure.
the format of the value is YYYY-MM-DD.
How do I allocate a new var in the SP and set it to the day before dep_date.
example.
dep_date is '2003-03-01', the local var should be '2003-02-28'
Where can I find SP documentation? And where can I find documentation of all functions that can be used in a SP?
Thanks,
Jonas
[Non-text portions of this message have been removed]
I get a char(10), called dep_date, as input to a stored procedure.
the format of the value is YYYY-MM-DD.
How do I allocate a new var in the SP and set it to the day before dep_date.
example.
dep_date is '2003-03-01', the local var should be '2003-02-28'
Where can I find SP documentation? And where can I find documentation of all functions that can be used in a SP?
Thanks,
Jonas
[Non-text portions of this message have been removed]