ASP.NET website & SQL Server - how to set local date / time and date format

Posted on 2009-04-28
Last Modified: 2012-05-06
Hi. I am hosting an ASP.NET website and SQL Server database in USA.

I am accessing this from New Zealand and want the system to display New Zealand local date / time and also date format dd/mm/yy instead of mm/dd/yy.

Is there a setting for web.config or something I can set so the site uses local date / time ?

Question by:dkmarsh
    LVL 14

    Accepted Solution


    There is no way you can do it from the server side until you maintain a profile of the users and the location in your database. But you can do it from client side.


    Expert Comment

    Yes you can.
    Add the following to your web config

           uiCulture="en-NZ" />
    LVL 14

    Expert Comment

    Yes. But it will display in NZ time zone for all the zones (including US)

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    I have developed many web applications with asp & and to add and use a dropdownlist was always a very simple task, but with the new, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
    IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now