
dbadmin=> SELECT * FROM dates;
mydate
------------
2018-07-10
2018-07-12
(2 rows)
dbadmin=> SELECT AVG(JULIAN_DAY(mydate)) + ‘4714-11-24 BC’::DATE avg_date
dbadmin-> FROM dates;
avg_date
———————
2018-07-11 00:00:00
(1 row)
Have fun!
Load Balancing on Elastic Kubernetes Clusters
Sruthi Anumula, Senior Database Support Engineer
March 7, 2023
Restrict Modifying Table Rows (UPDATE/DELETE) Irrespective of User Privileges
Sruthi Anumula, Senior Database Support Engineer
February 14, 2023
High Availability for a Vertica in Eon Mode Database with Read-Only Mode
Sruthi Anumula, Senior Database Support Engineer
January 9, 2023
How to Quickly Install Vertica on Large Clusters
Sruthi Anumula, Senior Database Support Engineer
December 19, 2022