Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - time zone problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

time zone problem
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
gupta_ji View Drop Down
Groupie
Groupie
Avatar

Joined: 29 October 2003
Location: India
Status: Offline
Points: 70 		Post Options Post Options   Thanks (0) Thanks(0)   Quote gupta_ji Quote  Post ReplyReply Direct Link To This Post Topic: time zone problem
    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. 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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#
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
gupta_ji View Drop Down
Groupie
Groupie
Avatar

Joined: 29 October 2003
Location: India
Status: Offline
Points: 70 		Post Options Post Options   Thanks (0) Thanks(0)   Quote gupta_ji Quote  Post ReplyReply Direct Link To This Post 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.



Edited by gupta_ji - 16 December 2009 at 8:17am
chartered accountants India, accounting Outsourcing ISO Certification
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.