The following query demonstrates a SQL Stored Procedure to add Custom Minutes in between time
Input for this Procedure
--------------------------
AddTime '09:30 AM' ,'5:30 PM' ,30
Procedure :
-------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[AddTime]
@StartTime varchar(10),
@EndTime varchar(10),
@TimeDiff int
as
begin
create table #DateParts (AddDate varchar(20))
Declare @Processfor int
Declare @EndProcess int
Declare @PreviousTime datetime
set @EndProcess =0
set @PreviousTime =convert(varchar, @StartTime, 108)
SELECT @Processfor=DATEDIFF(Hour,@StartTime ,@EndTime )
set @Processfor=@Processfor*2
while(@Processfor >0)
begin
if @EndProcess =@Processfor
begin
break
end
insert into #DateParts values(convert(varchar, DATEADD(mi, @TimeDiff,@PreviousTime), 108))
set @PreviousTime =convert(varchar, DATEADD(mi, @TimeDiff, @PreviousTime), 100)
set @EndProcess=@EndProcess+1
end
select * from #DateParts
end
 Attachments
QUERY File (34639-6713-AddTime.sql)SQL ADD Minutes in Time Format (34639-6716-AddTime.sql)
|
No responses found. Be the first to respond and make money from revenue sharing program.
|