[dbo].[ujo_time

[dbo].[ujo_time_offset]

(local) > mdb > Stored Procedures > dbo.ujo_time_offset

Properties
Parameters
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@time_in	varchar(30)	30

Permissions

Type	Action	Owning Principal
Grant	Execute	ujoadmin

SQL Script

/****** Object:  Stored Procedure dbo.ujo_time_offset    Script Date: 12/1/2005 11:49:14 PM ******/

CREATE PROC  ujo_time_offset
    @time_in  varchar(30)
AS

select datediff( ss, convert(datetime,@time_in,101), getdate() )

return -999 /*SUCCESS*/
GO
GRANT EXECUTE ON  [dbo].[ujo_time_offset] TO [ujoadmin]
GO

Uses