Re: Greenwich Mean Time (GMT) in Microsoft Access 2003

On Mon, 26 Sep 2005 02:37:50 GMT, "tpers" <tpers@xxxxxxxxxx> wrote:
>How can I convert a datetime value (i.e. now()) to Greenwich Mean Time(GMT)
>in Microsoft Access 2003?
>I have an Access database that is shared by a few people across different
>time zones. The database has a form that is time sensitive. The time field
>is in the Pacific time zone. By using the GMT value for the NOW() and the
>Time-Field, I am hoping that my friend in the Central zone can get the
>appropriate record based on his time zone, when the form opens.
>Is there another (easier) way to accomplish this task?
>I appreciate any help available.

Lyle's advice is the best so far in this thread (everyone else is
making it far more difficult then it needs to be, IMHO), *however*,
that said, be aware that no matter what you do you are going to get
"inconsistent" results. Everyone's clock is set to different times,
and depending upon when they last updated their computer's internal
clock and the rate at which their computer loses or gains time, it
won't be accurate to a central point.

The _best_ way to do this is to use a SQL Server Database and have the
Server set the time stamp. You'll have to regularly update the SQL
Server's clock, of course, but it will be _far_ more consistent then
having a bunch of computers writing what they hope the time is to the
database!



--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

.

Relevant Pages

  • Re: using time zones in ASP
    ... then record it somewhere, like a database. ... I'm pretty sure that timezone ... >I have an ASP app that works as an online time clock. ... How can I make the software know which time zone ...
    (microsoft.public.inetserver.asp.general)
  • Re: UTC offset for dates in the past?
    ... The tz database ... to time zone boundaries, UTC offsets, and daylight-saving ... zoneinfo data files on our z/OS system somewhere in /usr/lpp. ... For IBM-MAIN subscribe / signoff / archive access instructions, ...
    (bit.listserv.ibm-main)
  • Re: Time displayed on GPS
    ... >>approximation of time zone boundaries, ... You just need something like the unix tz database, ... Indiana has three different situations. ... 11 counties -- six near Chicago, IL, and five near ...
    (sci.geo.satellite-nav)
  • Re: using time zones in ASP
    ... >then record it somewhere, like a database. ... sure that timezone ... >>I have an ASP app that works as an online time clock. ... So what is the default time zone it uses? ...
    (microsoft.public.inetserver.asp.general)
  • Re: database timezone difference
    ... Because the timezones are different, when I pull the data it gets translated to local timezone. ... Locally, in North America, I need to process reports based on dates, and I need to have a report exactly as if it came from European database. ... If you want reports to have a time zone associated with them, then store the time zone to convert to as a property of the report. ...
    (comp.lang.ruby)