When we pass a DateTime data type to a .NET web service or when data is returned in a DataTable back to the client, all the DateTime fields are converted to match the destination timezone. For example, if the server runs in Eastern Time (GMT-5) and the Client runs in Indian Time (GMT+5:30), and we pass 6:00 PM to the server, the time is reflected at the server as 7:30 AM. Whereas this is okay in most situations because both times represent the same point in time, it is highly undesirable when we want to make a comparisons with a field in the database, etc. One solution I have come across on googling this is storing values as UTC in database, but this is not practical when we integrate web service into existing systems. I have my own ways of dealing with this issue (using some time functions, etc,), but i would like to know if there is something built into .NET (preferably .NET 2.0) to get around with this.
Thanks in advance