I want to do a delete with an inner join and the documentation says: DELETE statements support subqueries and joins, which is useful for deleting values in a table based on values that are stored in other tables. See the Examples section below. But when I run this delete aa.* from account_metric_agg...

Thanks!

How do I extract just the time from a timestamp to end up with a value that would go into a time column? I tried select TRUNC(TIMESTAMP '2012-02-12 12:00:00', 'HH:MI:SS'); But I got the following error [Vertica][VJDBC](5026) ERROR: Timestamp units "HH:MI:SS" not recognized [SQL State=22023, DB Error...