Help on SQL?

Question

How can I get information which occured on specific days of interval. For example all users who subscribed last week[FROM MONDAY TO SUNDAY]only.
Thanks in advance

I want to write a query that can return all user information from the database that has been added into my database in the last week for example.
Thanks again

Answer 1

Here's your answer for MS T-SQL:


--you'll need some variables
declare @pWkStart as smalldatetime
declare @pWkEnd as smalldatetime
declare @pWeekdayGetdate as varchar (30)
declare @pDayOffset as integer


--determine today's weekday
select @pWeekdayGetdate = datename(weekday, getdate())

--based on today's weekday, calculate the beginning of the previous full week beginning on a monday
select @pDayOffset =

case
when @pWeekdayGetdate = 'monday'
then 7
when @pWeekdayGetdate = 'tuesday'
then 8
when @pWeekdayGetdate = 'wednesday'
then 9
when @pWeekdayGetdate = 'thursday'
then 10
when @pWeekdayGetdate = 'friday'
then 11
when @pWeekdayGetdate = 'saturday'
then 12
when @pWeekdayGetdate = 'sunday'
then 13
end

--subtract the offset from today's date to establish the beginning of the period
select @pWkStart = DATEADD ( day , -@pDayOffset , getdate() )

--add six more days to bring it to sunday
select @pWkEnd = DATEADD ( day , 6 , @pWkStart )


--use it in a SELECT statement
select * from MyTable Where MyField between @pWkStart and @pWkEnd

Answer 2

Let's say the table that contains your user info is called USERS and the subscribed date is in a field called SUBSCRIBED and the dates are 08/21/06 through 08/27/06.

Select *
From USERS
Where SUBSCRIBED between '08/21/06' and '08/27/06'

Answer 3

what you need to do is:

1. add the date to your db when someone join the list

2. when running the query have (in pseudo code):

SELECT * FROM table WHERE date > %today - 7 days

Check your favourite SQL website to learn the exact syntax

Answer 4

I can help you out on this sql thing bit be specific what is the programming php? if it any discussion board then perhaps they might able to help you out better

Answer 5

You can do using if condition with sysday function in SQL.