Damodar Posted November 7, 2013 Share Posted November 7, 2013 Sir; I have developed a website for my Department of Science, which recently is hosted in USA. The website is programmed not to accept any form submissions after 8 pm. Also it gets redirected to "Site is down" page on Saturdays and Sundays. It was OK while the site was over in-house server. Now that its in USA, because the time zone now is different, it does not accept the forms after 8 pm in USA, which is 8 am here in India. Site does not accept forms from 8 am to 12 noon here in India. Also weekend redirect to "Site is down" is of no use due to date being different in USA and in India. Is there any code in ASP or procedure in SQL 2008 R2, whereby I can convert the USA time on the server in USA to Indian Standard Time ( IST ) so that the required functioning of the site happens as per the Indian Time and not as per the time in USA? We are on shared server so the server time can not be changed. Thanks DAMODAR G AGNI Link to comment Share on other sites More sharing options...
niche Posted November 7, 2013 Share Posted November 7, 2013 Why not just add hours to your query when someone claims to be from the US? Link to comment Share on other sites More sharing options...
justsomeguy Posted November 7, 2013 Share Posted November 7, 2013 If you're using ASP.net, there should be some information here: http://stackoverflow.com/questions/832986/how-to-work-with-timezone-in-asp-net That was linked from this question: http://stackoverflow.com/questions/7911296/asp-net-sql-server-set-time-zone Link to comment Share on other sites More sharing options...
davej Posted November 8, 2013 Share Posted November 8, 2013 Please post the code you are using now. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now