Date Time differences Firefox and IE
-
This one is throwing me for a doozie. Have a program that is recording times and writing to a database. We are in testing mode right now. We looked at the database during testing and noticed that sometimes the date were written in the mm/dd/yyyy and time in the 12-hr format. Other times it was in the dd/mm/yyyy and time in the 24-hr format. So I wrote a q&d to output dates and noticed that when using firefox the date was in dd//mm/yyyy format and when in IE the format was in mm/dd/yyyy format. But when we were testing we noticed that it sometimes would write in dd/mm/yyyy format from IE also. Sporadic. The site is on the web server and the database is also on the same web server. Anyone know how or why this would happen? Thanx in advance.
Jude
-
This one is throwing me for a doozie. Have a program that is recording times and writing to a database. We are in testing mode right now. We looked at the database during testing and noticed that sometimes the date were written in the mm/dd/yyyy and time in the 12-hr format. Other times it was in the dd/mm/yyyy and time in the 24-hr format. So I wrote a q&d to output dates and noticed that when using firefox the date was in dd//mm/yyyy format and when in IE the format was in mm/dd/yyyy format. But when we were testing we noticed that it sometimes would write in dd/mm/yyyy format from IE also. Sporadic. The site is on the web server and the database is also on the same web server. Anyone know how or why this would happen? Thanx in advance.
Jude
TheJudeDude wrote:
We looked at the database during testing and noticed that sometimes the date were written in the mm/dd/yyyy and time in the 12-hr format. Other times it was in the dd/mm/yyyy and time in the 24-hr format.
This tells me you're storing your date/times in your database as a String, not as a DateTime value. If so, this is a HUGE mistake that will cause you all kinds of headaches like this.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007