Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paulnamroud
Starting Member
26 Posts |
 Posted - 2010-01-08 : 09:43:50
|
| Hello,Our server is based in Canada and we are serving customers in Canada, UK and France. I would like to know how to save / update the right value of Date & Time in my tables cnsidering the time Zone between Canada, UK & France. For example, if my UK customer create a new order, i would to see in his table the date and time for UK Zone.Any help on how to save the right value of date and time depending on Customer Time Zone ??Thank you,Paul |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-08 : 09:52:36
|
That should not be a problem if the Date and time comes from the client.Edit: But honestly I have no experiences how it maybe usual to handle that.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2010-01-08 : 10:35:06
|
| You mention "his table". Do UK orders get stored in a different table then Canada orders?Another question:Lets say you (in Canada) are on the phone with a UK customer and you both enter an order at the same instant. When you look at those new orders in the table(s) should the entryDate be the same value or should they be 6 hours apart (or whatever the timezone difference is)? Sql datetimes don't have a notion of timezone so if the values should be six hours apart then you need a way to indicate the timezone offset for a given row.Another question:Assuming these international clients all share the same (physical) data server(s), what architecture are you using to submit a data change to the database? ie: distributed winforms application with web services calling stored procedures with typed parameters? or what?Be One with the OptimizerTG |
|
|
|
|
|
|
SQL Server & Time Zone