date and time difference from mysql table

Question

0.00/5 (No votes)

See more:

I have stored three essential timestamp and time into my database table, format as follows-

mysql> select receivedtime, requesttime, sla from table;
+---------------------+---------------------+----------+
| receivedtime        | requesttime         | sla      |
+---------------------+---------------------+----------+
| 2013-05-26 22:37:04 | 2013-05-26 12:37:04 | 02:59:59 |
| 2013-05-26 14:36:44 | 2013-05-21 12:39:09 | 72:00:00 |
+---------------------+---------------------+----------+
2 rows in set (0.00 sec)

I need to put few condition like below

difference = (receivedtime - requesttime);

CSS

if [difference <= sla]
{
   show meet
} else {
   show don't meet
}

legend:
receivedtime [timestamp] as because days
requesttime [timestamp] as because days
sla [time] as because hour

Need Help !

Posted 27-May-13 22:35pm

NightCodeStalker

Add a Solution

Comments

Jignesh Khant 28-May-13 5:24am

If u want time difference try this:

TimeSpan ts = DateTime.Parse(end) - DateTime.Parse(start);

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2013-05-28T02:18:00

Warning - I can't get to my MySQL instance at the moment so you may not be able to just copy&paste this ...

Try selecting from your database like this ...

select TIMESTAMPDIFF(SECOND, receivedtime, requesttime) as difference, TIME_TO_SEC(sla) as slasecs from table

and then you can do your

CSS

if [difference <= sla]
{
   show meet
} 
else 
{
   show don't meet
}