Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [oktell]
- GO
- /****** Object: UserDefinedFunction [dbo].[IntToTimeStr] Script Date: 30.07.2019 14:17:49 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- -- =============================================
- -- Author: <Author,,Name>
- -- Create date: <Create Date, ,>
- -- Description: <Description, ,>
- -- =============================================
- ALTER FUNCTION [dbo].[IntToTimeStr] (@number int) RETURNS nvarchar(50)
- AS
- BEGIN
- RETURN
- IIF(LEN(CAST(FLOOR(@number / 3600) as nvarchar(10))) = 1, '0' + CAST(FLOOR(@number / 3600) as nvarchar(10)), CAST(FLOOR(@number / 3600) as nvarchar(10)))
- + ':' +
- IIF(LEN(CAST(FLOOR(@number / 60 - FLOOR(@number /3600) * 60) as nvarchar(10))) = 1, '0' + CAST(FLOOR(@number/60 - FLOOR(@number / 3600) * 60) as nvarchar(10)), CAST(FLOOR(@number / 60 - FLOOR(@number / 3600) * 60) as nvarchar(10)))
- + ':' +
- IIF(LEN(CAST(FLOOR(@number - FLOOR(@number / 60) * 60) as nvarchar(10))) = 1, '0' + CAST(FLOOR(@number - FLOOR(@number / 60) * 60) as nvarchar(10)), CAST(FLOOR(@number - FLOOR(@number / 60) * 60) as nvarchar(10)))
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement