OK this might be a daft question but I’ll ask it anyway
All times are based on a 24 hour clock
What I need to do is collect some data in say Spain and as part of that data they enter a date/time of 31 July 2009 11:00
If someone in Spain looks at the data they will see it as 31 July 2009 11:00
When someone in say the UK looks at the data on screen I need to be able to display it as 31 July 2009 10:00 because the UK is 1 hour behind Spain
If someone in the USA looks at the data they may see something along the lines of 31 July 2009 05:00 (depending on where in the USA they are)
Basically I need to be able to collect a date/time and then show it to users in their local time rather than the time it was entered in the specific country
The data needs to be stored in a SQL database, probably 2005 if that makes any difference
Not sure if I have explained what I am trying to achieve very well but hopefully someone understands what I am getting at.
Thanks.
