DECLARE @StartTime DATETIME = '2011-09-23 15:00:00'
,@EndTime DATETIME = '2011-09-23 17:54:02'
SELECT CONVERT(VARCHAR(8), DATEADD(SECOND, DATEDIFF(SECOND,@StartTime, @EndTime),0), 108) as ElapsedTime
Subscribe to:
Post Comments (Atom)
-
SQL Server 2017 ---------------- Enterprise Core - 6GPYM-VHN83-PHDM2-Q9T2R-KBV83 Developer - 22222-00000-00000-00000-00000 Enterprise - ...
-
Step 1. Create Table Like below. CREATE TABLE [dbo].[Suppliers]( [SupplierID] [int] IDENTITY(1,1) NOT NULL, [CompanyName] [nvarchar](... -
Step 1.Open Visual studio and Create one aspx file name as Calculator. <form id="form1" runat="server"> ...
No comments:
Post a Comment