Date comparison problem

[noone]

Hi,

I am designing an application which displays news topics until midnight
on the DisplayUntil date and then they should drop out. Unfortunately,
they seem to be dropping out at mid-day.

I'm storing the 'DisplayFrom' and 'DisplayUntil' dates as SmallDateTime
fields so the date is in the format "25/09/2006 00:0:00" and I'm
comparing them with GetDate() which (I suspect) includes the actual time
as well.

I'm using the following SQL..

SELECT *
FROM t_news
WHERE n_DisplayUntil >= GetDate() AND n_DisplayFrom <= GetDate()

in MS SQL Server Express 2005

I think this is probably all too simplistic - is there a way to compare
these dates so that they display from the beginning of the start date
(ie 00:00:01) until the end of the last day (ie 23:59:59)?

I'm getting so desparate that I'm even considering pulling the whole
recordset and doing the comparison in VBScript - and that's desparate!
Can anyone help me, please?

Regards
ukwebguy

[Jens]

Re: Date comparison problem

Hi,

what about something like this here:

DECLARE @Start DATETIME
DECLARE @End DATETIME

SET @Start = '20060924'
SET @End = '20060924'

Select 1
Where @Start <= GETDATE() AND DATEDIFF(dd,GET DATE(),@END) >= 0

HTH, jens K. Suessmeyer.

---

http://www.sqlserver2005.de

---