High angle view of Beijing Guomao.
Vertica supports several special date/time values for our convenience. All of these values need to be written in single quotes when used as constants in SQL statements.
My favorite is ALLBALLS which is named so because the time digits look like balls (I had to Google that).
Example:
dbadmin=> SELECT timestamp 'today' midnight_today,
dbadmin-> timestamp 'yesterday' midnight_yesterday,
dbadmin-> timestamp 'tomorrow' midnight_tomorrow,
dbadmin-> time 'allballs' midnight_utc_time;
midnight_today | midnight_yesterday | midnight_tomorrow | midnight_utc_time
---------------------+---------------------+---------------------+-------------------
2018-10-15 00:00:00 | 2018-10-14 00:00:00 | 2018-10-16 00:00:00 | 00:00:00
(1 row)
Helpful link:https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/SQLReferenceManual/LanguageElements/Expressions/DateTimeExpressions.htm
Have fun!
About the Author
Phil Molea
Sr. Information Developer, Vertica
Phil developed technical documentation in the areas of security and diagnostics for the Vertica Analytics Platform that enabled companies to extract value from their data at the speed and scale they need to thrive in today’s economy.
(Sadly, Phil passed away recently. He will be missed.)
