I need to adjust the time to client's timezone. For that reason, I want to know the server's local time setting. thanks
How do I adjust the time in my application? The time in SQL server, .NET is all server time. When I add records to SQL Server it looks like central + 5 hours - which is GMT time.
Try looking at this blog post. http://www.4guysfromrolla.com/articles/081507-1.aspx http://www.codetoad.com/asp_converting_time.asp