Wednesday, May 8, 2013

date time format in sql server

Question  1 : 

How to get current date time in sql server?

Ans :      

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

Ans :

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)



If you are searching life partner. your searching end with now offer free matrimonial website which offer free message, free chat, free view contact information. so register here : Free matrimonial website