Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [oktell]
- GO
- /****** Object: UserDefinedFunction [dbo].[GetTimeFromSecond] Script Date: 07.08.2019 9:32:01 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- -- =============================================
- -- Author: <Author,,Name>
- -- Create date: <Create Date, ,>
- -- Description: <Description, ,>
- -- =============================================
- ALTER FUNCTION [dbo].[GetTimeFromSecond] (@sec int)
- RETURNS varchar(10) AS
- BEGIN
- return CONVERT(varchar(6), @sec/3600)+ ':' +
- RIGHT('0' + CONVERT(varchar(2), (@sec % 3600) / 60), 2) + ':' +
- RIGHT('0' + CONVERT(varchar(2), @Sec % 60), 2)
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement