extract time from timestamp(6)

Database
Enthusiast

extract time from timestamp(6)

Hi,

How to extract TIME from TIMESTAMP(6).

milliseconds are needed to get trimmed.

Thank you

1 REPLY
Highlighted
Enthusiast

Re: extract time from timestamp(6)

SELECT CAST(SUBSTR(CAST(<COL> AS VARCHAR(20)),12,19) AS TIME(0))