Query by Today's date

[Andy Burns]

I have been able to query a SQL Server database by submitting a specific date
or date range, however I am unable to query the database by todays date.
For example, my database is relating to a video shop. I need to find out
how many videos are due back today, without inputting the date.

[David Satz]

see getdate() IN BOL
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP1/7.0 SP3/6.5 SP5a } { Cold Fusion 5/4.5.1 SP2 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"Andy Burns" <bellerophon22@hotmail.com> wrote in message
news:3c3579e6$1@147.208.176.211...
>
> I have been able to query a SQL Server database by submitting a specific
date
> or date range, however I am unable to query the database by todays date.
> For example, my database is relating to a video shop. I need to find out
> how many videos are due back today, without inputting the date.