Results 1 to 3 of 3

Thread: [RESOLVED] (SQL2005) Set query condition as date

  1. Jun 14th, 2007, 06:38 AM #1
    GARAKWAZVO
    GARAKWAZVO is offline

    Thread Starter
    Member GARAKWAZVO's Avatar
    Join Date
    Mar 2007
    Location
    Zimbabwe
    Posts
    56

    Resolved [RESOLVED] (SQL2005) Set query condition as date

    Guys i want to set my query condition as current date how do i do that?

    say select * from Me where Date > Current date
    Reply With Quote Reply With Quote
  2. Jun 14th, 2007, 07:13 AM #2
    NPassero
    NPassero is offline
    Hyperactive Member NPassero's Avatar
    Join Date
    May 2007
    Location
    NJ
    Posts
    272

    Re: (SQL2005) Set query condition as date

    Code:
    SELECT * FROM [Me]
WHERE [Date] > GETDATE()
    returns anything greater than today's date -

    Reference:
    http://msdn2.microsoft.com/en-us/lib...3(SQL.90).aspx
    Reply With Quote Reply With Quote
  3. Jun 14th, 2007, 07:20 AM #3
    GARAKWAZVO
    GARAKWAZVO is offline

    Thread Starter
    Member GARAKWAZVO's Avatar
    Join Date
    Mar 2007
    Location
    Zimbabwe
    Posts
    56

    Re: [RESOLVED] (SQL2005) Set query condition as date

    thanks NPassero i finally figured it out liked this

    SELECT * FROM WHERE (B.EstimatedClosedate > (SELECT GETDATE() AS TodayDate))
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width