Counting Days, Week Days and Weekend Days Across the Years: Quick Tip
Sarah Lemaire, Manager, Vertica Documentation
July 17, 2018
Jim Knicely authored this post. By combing Vertica’s built-in date formatting functions and the TIMESERIES clause, it’s easy to find the total number of days, total number of week days (Monday - Friday), and the total number of weekend days (Saturday - Sunday) that occur within a multi-year range (i.e., 2016 - 2018), including Leap...