[dbo].[_time]

(local) > mdb > Scalar-valued Functions > dbo._time

Properties
Parameters
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@num	int	4

SQL Script

/****** Object:  User Defined Function dbo._time    Script Date: 12/1/2005 11:50:33 PM ******/

CREATE FUNCTION [dbo].[_time](@num int)
RETURNS varchar(20) AS
BEGIN
     RETURN LEFT(convert(varchar(20), dateadd(second, @num, '01/01/70'), 8), 5)
END
GO

Uses

Used By

[dbo].[statview]