Anyone for a Date? Date issues

Discussion in 'Databases' started by suchta, Sep 3, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. suchta

    suchta

    We are just completing development for an ASP application.

    Can you please tell me how we can best localise the time and date for our application. Obviously our SQL server is retrieving current system date and time of your server in the states. We are located in Melbourne Australia and would like the date and time to reflect our local time and date.

    Can you advise on how your international customers have done this in the past. We are looking for the simplest possible solution.
     
    suchta, Sep 3, 2003
    #1
  2. KPayne

    KPayne

    Store the UTC date in your database (GETUTCDATE()) and then add/subtract hours to it based on the timezone of the client.

    Keith Payne
    Technical Marketing Solutions
     
    KPayne, Sep 10, 2003
    #2
  3. Takeshi Eto

    Takeshi Eto DiscountASP.NET Staff

    Takeshi Eto, Sep 10, 2003
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page