how to get right 3 characters from a string in sql server

to get right 3 characters from a string,
the following code will help out

SELECT RIGHT('ASPDOTNET',3)

return value : NET

to get left 4 characters from a string in sql

To get the left characters from a string using sql server

QUERY
SELECT LEFT('ASPDOTNET',4)

RESULT
ASPD

To reverse a string

to reverse a given string in sql server, use the following query

Query

SELECT REVERSE('ASPDOTNET')

Result

TENTODPSA

how to get the no of days between two dates

to get the no of days between two dates,
use the following sql query

SELECT DATEDIFF(DAY,'2013-04-12',GETDATE())

return value : 265

add months to date

To add no.of months to a given date, use the following query

QUERY
SELECT DATEADD(M,2,GETDATE())

RESULT
if current month is august, the result is as follows
2013-10-01 14:57:41.143

get month name from date part

To get the month name from a given date, u should use the following query block

Query
SELECT DATENAME(MONTH, GETDATE())

Result
August

how to get the year part from a date

Query
SELECT YEAR(GETDATE())

Return value
2014

how to get weekend days from current month in sql server

WITH CTE(DATE, Cnt)AS(SELECT DATEADD(DAY, -DAY(GETDATE()-1), GETDATE()), 1
UNION ALL
SELECT DATE+1, Cnt+1 FROM CTE WHERE Cnt < (SELECT DAY(DATEADD(DAY, -DAY(DATEADD(MM, 1, GETDATE())), DATEADD(MM, 1, GETDATE())))))
SELECT DATENAME(WEEKDAY, DATE) AS WEEKDAYS, cnt INTO #MaskTable FROM CTE OPTION(MAXRECURSION 30)
SELECT * FROM #MaskTable WHERE WEEKDAYS IN('Saturday', 'Sunday')
-----------------------------------------
Saturday 6
Sunday 7
Saturday 13
Sunday 14
Saturday 20
Sunday 21
Saturday 27
Sunday 28

date convertion to yyyymmdd

To convert the date to yyyymmdd format in sql server

Query
SELECT CONVERT(VARCHAR(20), GETDATE(),112)

Return Value
20130801

convert date to yyyy/mm/dd in sql server

To convert the date to yyyy/mm/dd in sql server

Query
SELECT CONVERT(VARCHAR(20), GETDATE(),111)

Result
2013/08/01

how to convert date to dd-mm-yyyy format

To convert a given date to dd-mm-yyyy format in sql server,
use the following query

Query
SELECT CONVERT(VARCHAR(30), GETDATE(),110)

Return value
08-01-2013

To get current time in 24 hour format

Query
SELECT CONVERT(VARCHAR(20), GETDATE(),108)
Result
14:47:34

how to convert a date to dd monthname yyyy format

To convert a date to dd monthname yyyy format in sql

Query
SELECT CONVERT(VARCHAR(20), GETDATE(),106)

Result
01 Aug 2013

Sql Server - Date convertion to dd-mm-yyyy

To Convert the date to dd-mm-yyyy format, use the following query

Query
SELECT CONVERT(VARCHAR(20), GETDATE(),105)

Return Value
01-08-2013

how to convert date to dd.mm.yyyy format

To Convert the date to dd/mm/yyyy format, use the following query

Query
SELECT CONVERT(VARCHAR(20), GETDATE(),104)

Return Value
01.08.2013

Date convertion to dd/mm/yyyy in sql

To Convert the date to dd/mm/yyyy format, use the following query

Query
SELECT CONVERT(VARCHAR(10), GETDATE(),103)

Return Value
01/08/2013

convert date to yyyy.dd.mm format in sql

To convert the given date to a format like yyyy.dd.mm

Query
SELECT CONVERT(VARCHAR(11), GETDATE(),102)

Return Value
2013.08.01

how to convert date to mm/dd/yyyy format

to convert a given date to mm/dd/yyyy format in sql server,
use the following query

Query
SELECT CONVERT(VARCHAR(11), GETDATE(),101)

Return value
08/01/2013

how to get the name of the day in sql server

To get the name of a day in sql server

Query
SELECT DATENAME(weekday,getdate())

how to get total no of days in a month using sql server

To get the total no of days in a month in sql

Query

DECLARE @sample datetime
SET @sample=GETDATE()  -- Sample date
select datediff(dd,dateadd(dd, 1-day(@sample),@sample), dateadd(m,1,dateadd(dd, 1-day(@sample),@sample)))