Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql server - Time part of a DateTime Field in SQL

DECLARE @datetime datetime

SELECT @datetime = GETDATE()

SELECT RIGHT('0'+CAST(DATEPART(hour, @datetime) as varchar(2)),2) + ':' +
       RIGHT('0'+CAST(DATEPART(minute, @datetime)as varchar(2)),2)
Source by sqlerrors.com #
 
PREVIOUS NEXT
Tagged: #sql #server #Time #part #DateTime #Field #SQL
ADD COMMENT
Topic
Name
3+2 =