Sql server how to get current date as per setting -

we know people set date format dd/mm/yyyy in pc or may mm/dd/yyyy. want show date according system settings.

now doing way

convert(varchar(10),getdate(),101) dateonly; 

if possible please help

i don't think can done way trying to..

if user querying using query tool, there settings in query tool on how display dates.

if have application layer (web, client, etc) need format according locale somewhere.

this can

a) in sql on sql-server follows:

declare @d datetime = '01/01/2011'; select format ( @d, 'd', 'en-us' ) us_result; select format ( @d, 'd', 'fr-fr' ) fr_result; select format ( @d, 'd', 'de-de' ) de_result; 

(where app passes locale client through sql)

b) in app code .net/java using e.g. format class, etc.

public class formatdate {    public static void main()    {       datetime dt = datetime.now;       // sets currentculture property u.s. english.       thread.currentthread.currentculture = new cultureinfo("en-us");       // displays dt, formatted using shortdatepattern       // , currentthread.currentculture.       console.writeline(dt.tostring("d"));        // creates cultureinfo german in germany.       cultureinfo ci = new cultureinfo("de-de");       // displays dt, formatted using shortdatepattern       // , cultureinfo.       console.writeline(dt.tostring("d", ci));    } } 

c) in client e.g. if user looking @ web page you'll need use e.g javascript outlined here:

display date/time in user's locale format , time offset