0

Hi All,

I was trying to research my problem, but wasn't getting any results to satisfy me.

The problem is:

I am storing data in a mysql database (the server time is stored as well), I am also uploading data into this database from a file that was downloaded from another server (I have no access to this server). I have to generate reports doing a comparison but the dates are not matching up, and I am therefore not getting a proper report...the thing is that the lowest level of search criterion is the time, the level before that in the date (which works like a charm), but the data isn't accurate.

My question is:

Can I compare these 2 times to get an approximate result...taking into consideration the time goes down into seconds and milliseconds, etc...

2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by maydhyam
0

The TIMEDIFF function would be calculating the difference between 2 set of times...
unless you mean to say to calculate the difference between the 2 times...but it isn't comparing 2 individual times...there are 2 lists of times that needs to be compared...

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.