Forum Discussion
sql server previous day data extraction query
Hi All, I am trying to extract data of previous day from SQL server in Power BI. The table from which I am extracting data has a column with name 'CreatedOn' and has date and time. Can so...
- Select
*
From
Table
Where
Datediff(d,cast(createdon as date),cast(getdate() as date)) = 1
Select
*
From
Table
Where
Datediff(d,cast(createdon as date),cast(getdate() as date)) = 1
*
From
Table
Where
Datediff(d,cast(createdon as date),cast(getdate() as date)) = 1