Code: Select all
select TRUNC(TIMESTAMP '2012-02-12 12:00:00', 'HH:MI:SS');
Code: Select all
[Vertica][VJDBC](5026) ERROR: Timestamp units "HH:MI:SS" not recognized [SQL State=22023, DB Errorcode=5026]
Thanks!
Moderator: NorbertKrupa
Code: Select all
select TRUNC(TIMESTAMP '2012-02-12 12:00:00', 'HH:MI:SS');
Code: Select all
[Vertica][VJDBC](5026) ERROR: Timestamp units "HH:MI:SS" not recognized [SQL State=22023, DB Errorcode=5026]
Code: Select all
dbadmin=> select TO_CHAR(TIMESTAMP '2012-02-12 12:00:00', 'HH:MI:SS');
TO_CHAR
----------
12:00:00
(1 row)