SQL Server - Subtract/Add hours from date

SELECT DATEADD(HOUR,-1,DateTimesColumn)

or

select dateadd(HOUR, -8/2 ,'07/01/2018')

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

SQL Sever - Create a Copy of Table

SELECT * INTO BizDev.CurrCustomers FROM Sales.Customers

You can also create the new table from a specific subset of columns in the original table. In this case, you specify the names of the columns to copy after the SELECT keyword. Any columns not specified are excluded from the new table. The following example copies specific columns to a new table:

SELECT CustName, Address, Telephone, Email INTO BizDev.CurrCustomers

FROM Sales.Customers