How to extract day from timestamp in Vertica

This is an equivalent of DAY function in Oracle. To achieve this you will need to use the EXTRACT statement.

dbadmin= select now();
              now
-------------------------------

 2014-03-13 13:46:17.722358-03
(1 row)


dbadmin= SELECT EXTRACT (DAY FROM DATE 'now()');
 date_part
-----------

        13
(1 row)


dbadmin= SELECT EXTRACT (DAY FROM DATE '2012-01-11');
 date_part
-----------

        11
(1 row)