• Okay, I have created this code to convert the bigint into time.

    SELECT *, CONVERT(BIGINT(6), ACT_TIME, 114) AS NEW_ACT_TIME

    FROM dbo.tbl_table

    I receive this error:

    Msg 291, Level 16, State 1, Line 1

    CAST or CONVERT: invalid attributes specified for type 'bigint'

    I understand what I think it's saying... Since the length in my data is not always (6), I need to add CASE When (length) statments.... The only thing is, I don't know where to add this in my code. I have two lengths (see original data I sent). Can someone help me?