Member Avatar for maydhyam

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
  • 100 Views
  • 4 Weeks Discussion Span
  • Latest Post Latest Post by maydhyam
Member Avatar for pritaeas

Maybe you can use the TIMEDIFF function of mysql.

Member Avatar for maydhyam

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...

Member Avatar for maydhyam

anyone?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.