Jump to content
Damodar

Website time zone differs, need help!

Recommended Posts

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

Share this post


Link to post
Share on other sites

Why not just add hours to your query when someone claims to be from the US?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...