Search found 3 matches
- Fri Feb 06, 2015 7:53 pm
- Forum: New to Vertica SQL
- Topic: delete with inner join
- Replies: 1
- Views: 9070
delete with inner join
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...
- Fri Feb 06, 2015 7:49 pm
- Forum: New to Vertica SQL
- Topic: time only from timestamp
- Replies: 2
- Views: 7734
Re: time only from timestamp
Thanks!
- Mon Feb 02, 2015 9:04 pm
- Forum: New to Vertica SQL
- Topic: time only from timestamp
- Replies: 2
- Views: 7734
time only from timestamp
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...