Advertisement
WorkAkkaunt

Function Seconds to Time

Jul 30th, 2019
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.07 KB | None | 0 0
  1. USE [oktell]
  2. GO
  3. /****** Object:  UserDefinedFunction [dbo].[IntToTimeStr]    Script Date: 30.07.2019 14:17:49 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. -- =============================================
  9. -- Author:      <Author,,Name>
  10. -- Create date: <Create Date, ,>
  11. -- Description: <Description, ,>
  12. -- =============================================
  13. ALTER FUNCTION [dbo].[IntToTimeStr] (@number int) RETURNS nvarchar(50)
  14. AS
  15. BEGIN
  16.     RETURN
  17.     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)))
  18.         + ':' +
  19.     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)))
  20.         + ':' +
  21.     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)))
  22. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement