• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Time discrepancy

Hi

I have a web application (ColdFusion) and an MS Access 2003 application both working from the same server.

If I print out the current time using Now() on a web page and in an MS Access vba immediate window I get a discrepancy.

The web application shows me the hour is 16:58 while the MS Access shows me the hour is 17:58.  From my point of view the 17:58 is correct.

Can someone tell me how I can find a work around for this discrepancy.
0
Nemetona
Asked:
Nemetona
  • 2
  • 2
2 Solutions
 
Bill RossCommented:
Hi,

Since the access date is correct, it sounds like the web app is not adjusting for daylight time.  You need to determine where the date/time is coming from on the web app.

Regards,

Bill
0
 
_agx_Commented:
I'm not an Access person, but I believe it uses the o/s time.  CF uses the time and timezone settings in the jvm.  It sounds like there's a discrepancy between the two.  

Hopefully Bill can help explain how to check the timezone settings in Access. Here is how you can print out the timezone settings used by the CF server:

Now: <cfdump var="#now()#"><br>
Time Zone: <cfdump var="#getTimeZoneInfo()#">
CF Version: <cfdump var="#server.coldfusion#">
<cfset version = createObject("java", "java.lang.System").getProperty("java.version")>
Java: <cfdump var="#version#"><br>
<cfset tz = CreateObject("java", "java.util.TimeZone")>
<cfset tz = tz.getDefault()>
TimeZone: <cfdump var="#tz.getDisplayName()# (#tz.getID()#) "><br>

<cfset prop = createObject("java", "java.lang.System").getProperty("user.timezone")>
User.timezone =  <cfdump var="#prop#"><br> 

Open in new window


If the two are different, you may need to change the JVM timezone to match the one used by Access. But post the results of the above 1st, and we can go from there.
0
 
Bill RossCommented:
Hi,

Access does us the OS time.

Regards,

Bill
0
 
_agx_Commented:
@Bill - Ok, thanks. So most likely the jvm timezone settings are different than the o/s.


@Nemetona - What timezone is your o/s using? Also, please run the CF debugging code above and post the results.
0
 
NemetonaAuthor Commented:
I have been move to a different project and need to park this for the time being.  Thank you both for having responded.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now