Cast INTEGER to INTERVAL (seconds)

[dbmsuser7]

Right now I do this as

Code: Select all

CAST(my_integer::VARCHAR || ' s' AS INTERVAL)

Is there a less klunky way of doing it?

[id10t]

Hi!

[DELETED]

[dbmsuser7]

Thanks, sKwa! You are teh awesome!

Just for my own notes:

Code: Select all

vertica=> SELECT CAST(172 AS INTERVAL SECOND) - CAST(172::VARCHAR || ' s' AS INTERVAL) AS diff;
 diff 
------
 0
(1 row)

Kind of silly of me...I think I read the documention too zealously; they're very restrictive on what casts are allowed, even though those like the one in your method make obvious sense.

Thanks again!