date time format in sql server

Question  1 : 

How to get current date time in sql server?

Ans :      

      

  SELECT GETDATE()

Question 2:   How to get Only Date from  datetime  in sql server ?

Ans :

SELECT

CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond,

CONVERT(VARCHAR,GETDATE(),101) AS DateOnly(MM/dd/yyyy),

CONVERT(VARCHAR,GETDATE(),103) AS DateOnly(dd/mm/yyyy),

CONVERT(VARCHAR,GETDATE(),105) AS DateOnly(dd-mm-yyyy);

Question 3 :    How to add  minutes,hour,day  in specific Date  in sql server

Ans :

 we can do this using DATEADD function .

Syntax :

DATEADD (datepart , number , date )

Example :

select DATEADD (hour , 1 ,getdate()) as Addhour,

DATEADD (month , 1 , getdate()) as Addmonth,

DATEADD (minute , 1 , getdate()) as Addminute,

DATEADD (day , 1 , getdate()) as Addminute

Question 4 :    How to get YearMonth  Date Format in  sql server 

Ans :

Select  left(convert(varchar,getdate(),112),6)

Output

201305