Classic ASP Discussion - time zone problem

Print Page | Close Window

time zone problem

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=28142
Printed Date: 28 March 2026 at 7:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: time zone problem

Posted By: gupta_ji
Subject: time zone problem
Date Posted: 15 December 2009 at 2:45pm

I have hosted my site on USA server and I am from India, there is time zone difference of eleven and half hours. I am making a attendance system on my site, where user clicks on a link and the attendance is recorded in access database. But the problem is when the user is clicking on the link, it records USA time, what should I do to overcome this problem.

Thanks in advance for your help.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 15 December 2009 at 3:45pm

Use server side coding to get the time, add eleven and a half hours to it, and then save that to the database.

If you are using ASP have a look at the DateAdd Function built into ASP:-

http://www.w3schools.com/Vbscript/func_dateadd.asp

When saving dates and times to an Access database using SQL you need to place the dates within hash symbols eg:-

Date = #2008-15-11 18:30#

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: gupta_ji
Date Posted: 16 December 2009 at 4:15am

it worked with the time, thanks for that, now I am also facing problem with date, as the time difference is eleven and half hours.

-------------
http://www.sgrj.com" rel="nofollow - chartered accountants India , http://www.delhiprofessionals.com" rel="nofollow - accounting Outsourcing ISO Certification