skip to main
|
skip to sidebar
Monday, January 08, 2007
SQL Query to get records of Last 30 days
SELECT TOP 3 Id, Title, SubTitle, Place, CONVERT(varchar(15), Rdate, 106) AS Rdate, Content, Address, About, Comments FROM tbl_PressRelease WHERE (Rdate > DATEADD(day, - 30, GETDATE()))ORDER BY Id DESC
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Karthik
Karthik
Blog Archive
►
2008
(2)
►
June
(1)
►
January
(1)
▼
2007
(8)
►
September
(1)
►
August
(1)
►
February
(2)
▼
January
(4)
LAMP
RPM Commands
SQL Query to get records of Last 30 days
Google Language translator
►
2006
(1)
►
May
(1)
Links
Google News
About Me
Karthik
View my complete profile
No comments:
Post a Comment