Error using function DATEDIFF

[sumit.gadgilwar]

Error using function DATEDIFF
SELECT DATEDIFF('ss', TIME '04:44:42.315786', INTERVAL '2 05:55:52.963558');

Error: [Vertica][VJDBC](3457) ERROR: Function catalog.datediff(unknown, time, interval(in seconds)) does not exist, or permission is denied for catalog.datediff(unknown, time, interval(in seconds))
SQLState: HY000
ErrorCode: 3457

-------------------
Sumit Gadgilwar
-------------------

[JimKnicely]

Hi,

I believe that the 2nd and 3rd parameters of the DATEDIFF function must be of the same type. That is, they either have to be both TIME or BOTH INTERVAL.

In you case, maybe this is best?

Code: Select all

dbadmin=> SELECT DATEDIFF('ss', INTERVAL '0 04:44:42.315786', INTERVAL '2 05:55:52.963558');
 datediff
----------
   177070
(1 row)

[id10t]

Hi Sumit Gadgilwar!

Why you provides to us queries that you did copy/paste from Vertica Reference Manual version 3.5?
If it's not works, so may be you will read manual for your version?