ASP.NET, SQL Server, LINQTOSQL and Date formats

Question

I am setting the locale of my .net application via:

 string userLocale = Web.Helpers.LocaleHelpers.GetBestRFC3066Locale(this.Context.Request.UserLanguages);

            if (userLocale != String.Empty)
            {
                System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture(userLocale);
                System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo(userLocale);
            }

This works well, so my dates will be displayed in the format based upon the locale i.e.

12/10/2009 for en-gb and 10/12/2009 for us

However when I persist my dates via LinqToSql I need to store these dates in a common format.

Currently when a U.S. user is running the app the date stored in the DB is in U.S. format and when an U.K. user uses the app, its in a U.K. format.

Any suggestions on how best to achieve this?

Brannon · Accepted Answer · 2009-02-07 18:22:15Z

2

Store the date as a datetime value in SQL Server. Then you don't run into a conversion problem.

answered Feb 7, 2009 at 18:22

Brannon

26.2k5 gold badges42 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

StevenMcD · Accepted Answer · 2009-02-09 08:50:17Z

0

Brannon has the right solution there. Once you have a variable in a datetime format in SQL you can convert it to other datetime formats using the CONVERT T-SQL keyword

answered Feb 9, 2009 at 8:50

StevenMcD

17.6k12 gold badges45 silver badges56 bronze badges

Collectives™ on Stack Overflow

ASP.NET, SQL Server, LINQTOSQL and Date formats

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related