Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @OPERATOR uniqueidentifier
- DECLARE @TIME_START datetime
- DECLARE @TIME_FINISH datetime
- DECLARE @STATE int
- SET @TIME_START = '2018-04-06 11:01:00.000'
- SET @TIME_FINISH = '2018-04-06 11:31:00.000'
- SET @OPERATOR = '5EC13849-09B6-41DB-B0DA-9E36ACE5E461'
- SET @STATE = 8
- INSERT INTO [oktell_cc_temp].[dbo].[Operator_States_Test]
- (IdOperator, [State], DateTimeStart, DateStart, TimeStart, DateTimeStop, LenTime)
- VALUES(
- @OPERATOR
- ,@STATE
- ,@TIME_START
- ,CAST(CAST(@TIME_START AS date) AS datetime)
- ,CAST(CAST(@TIME_START AS time) AS datetime)
- ,@TIME_FINISH
- ,DATEDIFF(second, @TIME_START, @TIME_FINISH)
- )
Advertisement
Add Comment
Please, Sign In to add comment