PDA

View Full Version : Anyone for a Date? Date issues


suchta
09-03-2003, 08:28 AM
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.

KPayne
09-10-2003, 09:16 AM
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

Eric
09-10-2003, 09:26 AM
Please see: http://forum.discountasp.net/topic.asp?TOPIC_ID=405