dbadmin=> SELECT INTERVAL '24 HOURS' / INTERVAL '1 DAY' days;
days
------
1
(1 row)
dbadmin=> SELECT INTERVAL ’36 HOURS’ / INTERVAL ‘1 DAY’ days;
days
——
1.5
(1 row)
dbadmin=> SELECT INTERVAL ‘1 DAY’ / INTERVAL ‘2 HOURS’ hours;
hours
——-
12
(1 row)
dbadmin=> SELECT INTERVAL ‘1 YEAR’ / INTERVAL ‘1 SECOND’ seconds;
seconds
———-
31536000
(1 row)
Have fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
