Tag Archives: dateformat

Change Default Language/ Date Format in SQL

Usually in SQL, date gets saved as ‘2009-07-27 00:00:00.000’ but when we run the query or call date from any application the SQL gives us the date in desired format like ’07/27/2009’. How does it work? SQL has set of formats according to the different languages for example ‘British’, ‘Dutch’, ‘German’, ‘English’ etc. By Default… Read More »