All Forums Database
Kuldeepg92 5 posts Joined 08/16
25 Aug 2016
extract time from timestamp(6)

Hi,
How to extract TIME from TIMESTAMP(6).
milliseconds are needed to get trimmed.
Thank you

29 Aug 2016

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

You must sign in to leave a comment.