Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
Search Forums
»
Search Results
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
LIB - func Yesterday.sql
Wed, Feb 8 2012 7:31 AM
Permanent Link
Lucian
CREATE
FUNCTION "Yesterday" ()
RETURNS DATE
BEGIN
DECLARE Result DATE;
SET Result = CURRENT_DATE - INTERVAL '1' DAY;
RETURN Result;
END
DESCRIPTION 'Date function to return yesterday''s date.'