Link to home
Create AccountLog in
Avatar of nverfollowtt

asked on

Datetime issue as of Today - Early this morning

I'm seeking advice on a recent bug which I believe is due to daylight savings time.

This morning I noticed that the date/time elements on my project were incorrect. Items on the site will say 2 hours ago or 1 min ago etc. how they are saying -1hr ago or -3600s ago, which is exactly an hour in the future.

My understand is that Coldfusion and MS SQL Server 2005 all use the server's time when using the GETDATE() type functions. Does anyone have any idea why there would be a discrepancy?

Avatar of chapmandew
Flag of United States of America image

Did you confirm that the date on the server and the client computer(s) changed?
Avatar of nverfollowtt


They did change I checked. I believe the issue is that Coldfusion uses java which does not know the computer is in CDT.
Hmmm....that is interesting.  How are you going to solve it?
Avatar of Zvonko
Flag of North Macedonia image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I need to update Java apparently this become a problem as of last year.