I have a time stored in HS format. So the time will look like '0 20:50:00.000000'.
I need to convert this to the data type time. When I simply try to
cast(HStime to time)
I get the error, invalid operation on datetime or interval.
Another proposed solution for this online is:
However, this gave me the error 'Syntax error: expected something between the word 'HStime' and the 'SECOND' keyword'
Please help clarify how a HS interval can be converted to hour:minute:second