แยกวันที่และเวลาออกเป็นส่วนประกอบ

DECLARE
	@BerlinWallFalls DATETIME2(7) = '1989-11-09 23:49:36.2294852';

-- Fill in each date part
SELECT
	DATEPART(____, @BerlinWallFalls) AS TheYear,
	DATEPART(____, @BerlinWallFalls) AS TheDayOfYear,
	DATEPART(____, @BerlinWallFalls) AS TheDay,
	DATEPART(____, @BerlinWallFalls) AS TheWeek,
	DATEPART(____, @BerlinWallFalls) AS TheSecond,
	DATEPART(____, @BerlinWallFalls) AS TheNanosecond;