Extracting data from MSSQL using PHP in a desired format

Question

I have a MS Sql table already made. Each row has a column called RECORD_DATE which consists of the current date. How should I query to always extract the previous days(yesterdays date) row data on the current day? Also this table is dynamic, it keeps inserting and updating a new row(s) everyday but the date is unique to a particular row.

Here is the example [Click here](https://stackoverflow.com/questions/1503298/sql-statement-to-select-all-rows-from-previous-day) — Suneel Kumar, Jun 28 '17 at 11:08

score -1 · Answer 1 · answered Jun 28 '17 at 11:08

-1

Use mysql Function like this

SELECT * FROM tb WHERE DATEDIFF(now(),dt) = 1

answered Jun 28 '17 at 11:08

Rohit Dalal

856
9
12

the question is tagged sql-server – A ツ Jun 28 '17 at 11:56

Extracting data from MSSQL using PHP in a desired format

1 Answers1