SQL: Get detailed date and time parts from datetime value

DECLARE @mydatetime DATETIME

DECLARE @myms int
DECLARE @myss int
DECLARE @mymi int
DECLARE @myhh int
DECLARE @mydd int
DECLARE @mymm int
DECLARE @myyyyy int

SET @mydatetime=getdate()
SET @myms = DATEPART(ms,@mydatetime)
SET @myss = DATEPART(ss,@mydatetime)
SET @mymi = DATEPART(mi,@mydatetime)
SET @myhh = DATEPART(hh,@mydatetime)
SET @mydd = DATEPART(dd, @mydatetime)
SET @mymm=DATEPART(mm,@mydatetime)
SET @myyyyy = DATEPART(yyyy, @mydatetime)

SELECT @myyyyy AS 'Year', @mymm AS 'Month', @mydd AS 'DayOfMonth',
@myhh AS 'Hour', @mymi AS 'Minute', @myss AS 'Second',
@myms AS 'Millisecond'

Result:

Year        Month       DayOfMonth   Hour        Minute      Second      Millisecond

----------- ----------- ------------ ----------- ----------- ----------- -----------
2013        3           11           13          27          38          203



(1 row(s) affected)