how to get time part from datetime in sql server

4

Reply

how to get time part from datetime in sql server

Anand N

12y

1.2k

0

select convert(varchar(15),getdate(),114)

12y

select convert(varchar(15),getdate(),114)

12y

select convert(varchar(15),getdate(),114)

12y

Kundan Kumar

SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSec

12y