SQL Server Date Formats

There are several date formats available in the SQL like the following few formats

• mm/dd/yy
• mm/dd/yyyy
• dd.mon.yyy

for complete list of the SQL date fromats use the this link Date Formats.