Cast smallint to time

General
Enthusiast

Cast smallint to time

How can i cast smallint value to time.

Please help.
1 REPLY
Enthusiast

Re: Cast smallint to time

How is the time stored in your smallint? The largest value in a smallint is 32767 so it cannot be hhmmss format or seconds since midnight. (Unless your times are restricted to very early hours only!)