Date Formats

select convert(nvarchar,Date_contd,100) from [TableName]
Jul 24 2007 12:00AM
Jul 25 2007 12:00AM

select convert(nvarchar,Date_contd,101)as Dates from [TableName]
07/24/2007
07/25/2007

select convert(nvarchar,Date_contd,102)as Dates from [TableName]
2007.07.24
2007.07.25

select convert(nvarchar,Date_contd,103)as Dates from [TableName]
24/07/2007
25/07/2007

select convert(nvarchar,Date_contd,104)as Dates from [TableName]
24.07.2007
25.07.2007

select convert(nvarchar,Date_contd,105)as Dates from [TableName]
24-07-2007
25-07-2007

select convert(nvarchar,Date_contd,106)as Dates from [TableName]
24 Jul 2007
25 Jul 2007

select convert(nvarchar,Date_contd,107)as Dates from [TableName]
Jul 24, 2007
Jul 25, 2007

select convert(nvarchar,Date_contd,108)as Dates from [TableName]
00:00:00
00:00:00

select convert(nvarchar,Date_contd,109)as Dates from [TableName]
Jul 24 2007 12:00:00:000AM
Jul 25 2007 12:00:00:000AM

select convert(nvarchar,Date_contd,110)as Dates from [TableName]
07-24-2007

select convert(nvarchar,Date_contd,111)as Dates from [TableName]
2007/07/24
2007/07/25

select convert(nvarchar,Date_contd,112)as Dates from [TableName]
20070724
20070725

select convert(nvarchar,Date_contd,113)as Dates from [TableName]
24 Jul 2007 00:00:00:000
25 Jul 2007 00:00:00:000

select convert(nvarchar,Date_contd,114)as Dates from [TableName]
00:00:00:000
00:00:00:000

Here Date_contd is Column name in the Table

Read More