Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
Thread LIB - func Yesterday.sql
Wed, Feb 8 2012 7:31 AMPermanent 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.'
Image