SQL server queries the data within the specified range (one week, one month, this week, this month, etc.)

From , 4 Years ago, written in SQL, viewed 54 times.

SELECT * FROM ShopOrder WHERE datediff(week,ordTime,getdate()-1)=0   
 
 

Reply to "SQL server queries the data within the specified range (one week, one month, this week, this month, etc.)"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?

Spam protection Type in the letters