Posted by AlterEgo on 03/20/07 22:02

t8ntboy,

You might want to use CURRENT_TIMESTAMP which is ANSI compliant and
equivalent to GETDATE(). There is no functional difference, its just easier
for someone coming from another DB platform to understand.

-- Bill

"t8ntboy" <t8ntboy@gmail.com> wrote in message
news:1174421409.303027.198580@l75g2000hse.googlegroups.com...
>I am using SQL Server Express and ASP.
>
> I have a table that contains news articles, headlines, start and end
> dates. I am trying to create a recordset that shows all of the
> articles that are greater than or equal to the start date and less
> than or equal to the end date. For some reason I cannot get it to
> function properly using a statement similar to StartDate >= Now() AND
> EndDate <= Now(). SQL doesnt like the Now() piece of the statement.
> Anyone have an idea how I can get this to work? I have also tried
> CURDATE() but to no avail.
>
>
> Please help.
>

• Next in forum: Multiple db query call from within different context into #temp table
• Prev in forum: Re: Quick SQL Select Statement ?
• Thread view: Re: Quick SQL Select Statement ?

[Reply to this message]