CODEWITHSUNDEEP
sql-server-2005datetime
Fry
Fry

Reputation: 4286

Specific Time Range Query in SQL Server

I'm trying to query a specific range of time:

I've seen that you can get data for a particular range, but only for start to end and this is quite a bit more specific. I didn't see any SQL Server commands that would directly help me on this, so does anybody else have any thoughts on how you would form this?

I've seen this, but I don't think it's nearly specific enough for this range.

Thanks!

Upvotes: 28

Views: 215921

Answers (5)

Mandeep Kaur
Mandeep Kaur

Reputation: 1

If you want to get results for specific time period, use the query below:

Select * from [your_table_name] 
where date between '2021-10-05' AND '2021-12-10'

Upvotes: -1

Z.storch
Z.storch

Reputation: 31

I (using PostgrSQL on PGadmin4) queried for results that are after or on 21st Nov 2017 at noon, like this (considering the display format of hours on my database):

select * from Table1 where FIELD >='2017-11-21 12:00:00'

Upvotes: 2

Giggy
Giggy

Reputation: 536

I'm assuming you want all three of those as part of the selection criteria. You'll need a few statements in your where but they will be similar to the link your question contained.

SELECT *
  FROM MyTable
  WHERE [dateColumn] > '3/1/2009' AND [dateColumn] <= DATEADD(day,1,'3/31/2009') 
        --make it inclusive for a datetime type
    AND DATEPART(hh,[dateColumn]) >= 6 AND DATEPART(hh,[dateColumn]) <= 22 
        -- gets the hour of the day from the datetime
    AND DATEPART(dw,[dateColumn]) >= 3 AND DATEPART(dw,[dateColumn]) <= 5 
        -- gets the day of the week from the datetime

Hope this helps.

Upvotes: 36

northpole
northpole

Reputation: 10346

you can try this (I don't have sql server here today so I can't verify syntax, sorry)

select attributeName
  from tableName
 where CONVERT(varchar,attributeName,101) BETWEEN '03/01/2009' AND '03/31/2009'
   and CONVERT(varchar, attributeName,108) BETWEEN '06:00:00' AND '22:00:00'
   and DATEPART(day,attributeName) BETWEEN 2 AND 4

Upvotes: 6

Tolgahan Albayrak
Tolgahan Albayrak

Reputation: 3206

select * from table where 
(dtColumn between #3/1/2009# and #3/31/2009#) and 
(hour(dtColumn) between 6 and 22) and 
(weekday(dtColumn, 1) between 2 and 4)

Upvotes: 0

Related Questions