Sau un câmp de timp SMALLINT (2 octeţi):
CREATE TABLE TabelaTimp
(
Id INT IDENTITY PRIMARY KEY,
Timp SMALLINT
);
GO
INSERT INTO TabelaTimp(Timp) VALUES (2345);
INSERT INTO TabelaTimp(Timp) VALUES (103);
INSERT INTO TabelaTimp(Timp) VALUES (5);
GO
CREATE FUNCTION Ora(@p_timp SMALLINT)
RETURNS TINYINT
AS
BEGIN
DECLARE @rezultat TINYINT
SET @rezultat = @p_timp / 100
RETURN @rezultat
END
GO
CREATE FUNCTION Minut(@p_timp SMALLINT)
RETURNS TINYINT
AS
BEGIN
DECLARE @rezultat TINYINT
SET @rezultat = @p_timp % 100
RETURN @rezultat
END
GO
SELECT * , dbo.Ora(Timp) AS O , dbo.Minut(Timp) AS M
FROM TabelaTimp