RETAIL_START_END

Syntax


Description of retail_start_end_fn.eps follows
Description of the illustration retail_start_end_fn.eps

  • dtexpr is a datetime expression with one of the following types (or any value that can be implicitly converted to DATE): DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE .

  • All retail functions take an optional is_restated parameter that controls how years that require 53 weeks are handled.

    The is_restated parameter is a text expression that must resolve to either RESTATED or NOT RESTATED (case-insensitive). A retail year typically contains exactly 52 weeks, which is 364 days. Therefore, every 5 or 6 years an extra 53rd week is added. This is a non-restated calendar and is what is produced when the is_restated parameter is NOT RESTATED (the default). Some users prefer to have all years contain 52 weeks for comparison purposes. Such calendars are called restated calendars, and is what is produced when the is_restated parameter is RESTATED.