Re: Date Query

From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 23 Jul 2006 16:29:21 +0200

On Thu, 20 Jul 2006 16:37:01 -0700, Samson wrote:

I need to query between todays date +14. Any suggestions on code. Thanks.

Hi Samson,

DECLARE @Today datetime
SET @Today = DATEADD(day, 0, DATEDIFF(day, CURRENT_TIMESTAMP, 0))

SELECT some columns
FROM your table
WHERE DateColumn >= @Today
AND DateColumn < DATEADD(day, 15, @Today)

--
Hugo Kornelis, SQL Server MVP
.

Next by Date: Re: Data in wrong columns after query changed
Next by thread: Re: Data in wrong columns after query changed
Index(es):
- Date
- Thread

Relevant Pages

Re: Is there any method for getting definite number of records?
... ORDER BY dateColumn DESC ... SQL Server MVP ... "Ray" wrote in message ... Is there any sql statement for getting the ...
(microsoft.public.sqlserver.programming)
Re: CONVERSION FROM CHAR(4) TO DATETIME
... J_TIM is datetime while F_TIM is char of 4 ... how can i convert F_TIM to datetime so that i can compare them. ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)
Re: CONVERSION FROM CHAR(4) TO DATETIME
... J_TIM is datetime while F_TIM is char of 4 ... how can i convert F_TIM to datetime so that i can compare them. ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)