Vertica Blog

Vertica Blog

date

List the Missing Dates in a Date Series

James Knicely, Vertica Field Chief Technologist
October 22, 2020

The TIMESERIES clause in Vertica makes it easy to list all of the gap days (that is, those that are missing) from a series of dates. Say I have this simple date series: As you can see, there are several dates missing from the series (2020-10-30, 2020-11-02, 2020-11-03 and 2020-11-04). I can list these absent...

It’s All About Timing

Sarah Lemaire, Manager, Vertica Documentation
March 15, 2016

Every so often we hear about the seemingly confusing nature of SQL functions that return the “current” time. But what is “current”? Is it the start time of a transaction or statement? Is it the time returned by the system clock? The answer is: all of these, depending on which function you call.