How to get Time from DateTime in SQL Server

Hi nedash,

Below is the query.

SELECT CONVERT(VARCHAR(7),GETDATE(),108) [Time]

hi dharmendr

below is SP

USE [Digimaster]
GO
/****** Object:  StoredProcedure [dbo].[Oreder_Insert]    Script Date: 10/26/2016 18:58:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[Oreder_Insert]
@State nvarchar(50)
,@City nvarchar(50)
,@Zone nvarchar(50)
,@Name nvarchar(100)
,@Address nvarchar(MAX)
,@PCode varchar(10)
,@Email varchar(100)
,@Mobile varchar(20)
,@Tell varchar(20)
,@PType nvarchar(50)
,@PName nvarchar(100)
,@PostCode varchar(30)
,@PSectionName nvarchar(100)
,@Format varchar(20)
,@OrderType nvarchar(50)
,@Quantity varchar(5)
,@PriceP varchar(5)
,@PriceT varchar(10)
,@PriceTotal varchar(20)
,@PriceTotalBaste  varchar(20)
,@PostType nvarchar(50)
AS
BEGIN
INSERT INTO  Order_Users
(Name,[State] ,City,Address,PCode,Email ,Mobile ,Tell ,PType ,PostCode,PName,PSectionName 
,Format,OrderType ,Quantity ,PriceP ,PriceT ,PriceTotal,PostType,PriceTotalBaste,zone ,[date],Time)
VALUES
(@Name,@State ,@City,@Address,@PCode,@Email ,@Mobile ,@Tell ,@PType ,@PostCode,@PName ,@PSectionName 
,@Format,@OrderType ,@Quantity ,@PriceP ,@PriceT ,@PriceTotal ,@PostType,@PriceTotalBaste,@Zone,GETDATE(),SELECT CONVERT(VARCHAR(7),GETDATE(),108) [Time])
END

but this error happen:

Msg 156, Level 15, State 1, Procedure Oreder_Insert, Line 37 Incorrect syntax near the keyword 'SELECT'. Msg 102, Level 15, State 1, Procedure Oreder_Insert, Line 37 Incorrect syntax near ')'.

nedash says:

ALTER procedure [dbo].[Oreder_Insert]

@State nvarchar(50)

,@City nvarchar(50)

,@Zone nvarchar(50)

,@Name nvarchar(100)

,@Address nvarchar(MAX)

,@PCode varchar(10)

,@Email varchar(100)

,@Mobile varchar(20)

,@Tell varchar(20)

,@PType nvarchar(50)

,@PName nvarchar(100)

,@PostCode varchar(30)

,@PSectionName nvarchar(100)

,@Format varchar(20)

,@OrderType nvarchar(50)

,@Quantity varchar(5)

,@PriceP varchar(5)

,@PriceT varchar(10)

,@PriceTotal varchar(20)

,@PriceTotalBaste  varchar(20)

,@PostType nvarchar(50)

AS

BEGIN

INSERT INTO  Order_Users

(Name,[State] ,City,Address,PCode,Email ,Mobile ,Tell ,PType ,PostCode,PName,PSectionName

,Format,OrderType ,Quantity ,PriceP ,PriceT ,PriceTotal,PostType,PriceTotalBaste,zone ,[date],Time)

VALUES

(@Name,@State ,@City,@Address,@PCode,@Email ,@Mobile ,@Tell ,@PType ,@PostCode,@PName ,@PSectionName

,@Format,@OrderType ,@Quantity ,@PriceP ,@PriceT ,@PriceTotal ,@PostType,@PriceTotalBaste,@Zone,GETDATE(),SELECT CONVERT(VARCHAR(7),GETDATE(),108) [Time])

 Replace with

ALTER procedure [dbo].[Oreder_Insert]
@State nvarchar(50)
,@City nvarchar(50)
,@Zone nvarchar(50)
,@Name nvarchar(100)
,@Address nvarchar(MAX)
,@PCode varchar(10)
,@Email varchar(100)
,@Mobile varchar(20)
,@Tell varchar(20)
,@PType nvarchar(50)
,@PName nvarchar(100)
,@PostCode varchar(30)
,@PSectionName nvarchar(100)
,@Format varchar(20)
,@OrderType nvarchar(50)
,@Quantity varchar(5)
,@PriceP varchar(5)
,@PriceT varchar(10)
,@PriceTotal varchar(20)
,@PriceTotalBaste  varchar(20)
,@PostType nvarchar(50)
AS
BEGIN
INSERT INTO  Order_Users(
Name,[State] ,City,Address,PCode,Email ,Mobile ,Tell ,PType ,PostCode,PName,PSectionName
,Format,OrderType ,Quantity ,PriceP ,PriceT ,PriceTotal,PostType,PriceTotalBaste,zone ,[date],[Time])
VALUES(
@Name,@State ,@City,@Address,@PCode,@Email ,@Mobile ,@Tell ,@PType ,@PostCode,@PName ,@PSectionName
,@Format,@OrderType ,@Quantity ,@PriceP ,@PriceT ,@PriceTotal ,@PostType,@PriceTotalBaste,@Zone,GETDATE(),CONVERT(VARCHAR(7),GETDATE(),108))
END

dharmendr says:

CONVERT(VARCHAR(7),GETDATE(),108)

 ok it worked

but I want it just save hours and minutes like 5:25

Use VARCHAR(5) instead of VARCHAR(7)

CONVERT(VARCHAR(5),GETDATE(),108)