- CREATE FUNCTION [dbo].TotalTime
- (
- @StartTime DATETIME,
- @EndTime DATETIME
- )
- RETURNS Varchar(10)
- AS
- begin
- DECLARE @D VARCHAR(400)='31784'
- Declare @outTime Varchar(10);
- SELECT @D = DATEDIFF(SECOND,@StartTime,@EndTime)
- SELECT @outTime =CONVERT(VARCHAR(5), @D/60/60)
- + ':' + RIGHT('0' + CONVERT(VARCHAR(2), @D/60%60), 2)
- + ':' + RIGHT('0' + CONVERT(VARCHAR(2), @D % 60), 2)
- RETURN @outTime
- END
- GO
- SELECT dbo.TotalTime('2016-08-10 10:36:01.000','2016-08-10 19:25:45.000')
Tuesday, 6 December 2016
SQL Function Get Total Time in HH:MM:SS
Subscribe to:
Post Comments (Atom)
Upload valid file in C#
protected bool CheckFileExtandLength(HttpPostedFile HtmlDocFile) { try { Dictionary<string, byte[]...
-
Setting Header Programatically You can also set the cache headers programmatically. This can be useful for generated content and allows m...
-
CREATE TABLE dbo.M_Bank ( ID INT IDENTITY NOT NULL, MB_NAME NVARCHAR (50), MB_SNAME NVARCHAR (20), MB_ADDUSER ...
-
SELECT distinct(volume_mount_point), total_bytes/1048576 as Size_in_MB, total_bytes/1048576/1024 as Size_in_GB, available_bytes/1048576 ...
No comments:
Post a Comment