SQL Server - How to extract only Year/Hour/Min from the date

Try running following

select year('01/07/2018')
select year(@date)
select year(getdate())
select year('20180101')

----------------- or use datepart.



select datepart(HOUR,ColumnWithDateTime)
select datepart(YEAR,ColumnWithDateTime)
select datepart(MI,ColumnWithDateTime)

datepart	Abbreviations
year	yy, yyyy
quarter	qq, q
month	mm, m
dayofyear	dy, y
day	dd, d
week	wk, ww
weekday	dw
hour	hh
minute	mi, n
second	ss, s
millisecond	ms
microsecond	mcs
nanosecond	ns
TZoffset	tz
ISO_WEEK	isowk, isoww