Query by Today's date


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Query by Today's date

  1. #1
    Andy Burns Guest

    Query by Today's date


    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.

  2. #2
    David Satz Guest

    Re: Query by Today's date

    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.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center