ok I write new query:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Oreder_Insert]
AS
BEGIN
INSERT INTO Order_Users
(Time)
VALUES
(CONVERT(VARCHAR(5),GETDATE(),108))
END
and run it:
exec Oreder_Insert
resualt was
20:02:00
it doesn't insert second but it inser 00 instead of second:
like 19:52:00 or 20:15:00