The table called fault_aggregation. Result Grid | EE Fiter Rows: Export: FaultNa

Question

The table called fault_aggregation. Result Grid | EE Fiter Rows: Export: FaultName numberoccurances Date Time 00000000002 2018-03-07 15:09:30 Air Lost E-Stop Overfill000000000012018-03-07 15:09:30 00000000002 2018-03-07 15:09:30 TEST ME 00000000012018-03-07 15:09:30 Underfill 00000000001 Air Lost00000000002 E-Stop00000000002 Overfill 00000000001 TEST ME 00000000001 Under fill 00000000001 Air Lost 00000000002 E-Stop 00000000003 Overfill00000000001 TEST ME 00000000001 Underfll 00000000001 Air Lost 00000000002 E-Stop 00000000003 Overfill TEST ME 00000000001 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 2018-03-07 15:09:30 00000000001 Result 122fault aggregation 123 x

Explanation / Answer

Given below query tells about records to display ,which are over 2 days older

MySql>SELECT * FROM fault_aggregation where DateTime > DATE_ADD(NOW(), INTERVAL -2 DAY)

note:- 1)NOW() returns DATETIME

            2)INTERVAL works as e.g INTERVAL -2 DAY = -48 hours

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.