showing that a date is greater than current date

Question

How would I show something in SQL where the date is greater than the current date    I want to pull out data that shows everything greater from today  now  for the next coming 90 days     I was thinking   lt   fn NOW    but that doesnt seem to work in my sql view here    How can this be done

User · Accepted Answer

SELECT    FROM MyTable  WHERE CreatedDate  gt   getdate    AND CreatedDate  lt   dateadd day  90  getdate      http   msdn microsoft com en-us library ms186819 aspx

User · Answer

For those that want a nice conditional   DECLARE  MyDate DATETIME     some date in future  --example  DateAdd day 5 GetDate     IF  MyDate  lt  DATEADD DAY 1 GETDATE        BEGIN         PRINT  Date NOT greater than today     END ELSE      BEGIN        PRINT  Date greater than today     END

User · Answer

Assuming you have a field for DateTime  you could have your query look like this   SELECT   FROM TABLE WHERE DateTime  gt   GetDate     90

User · Answer

If you re using SQL Server it would be something like this   DATEDIFF d GETDATE   FUTUREDATE  BETWEEN 0 AND 90

User · Answer

Select   from table where date  gt   Today s date mm dd yyyy     You can also add time in the single quotes 00 00 00AM   For example   Select   from Receipts where Sales date  gt   08 28 2014 11 59 59PM

User · Answer

In sql server  you can do   SELECT   FROM table t WHERE t date  gt  DATEADD dd 90 now

User · Answer

For SQL Server  select   from YourTable where DateCol between getdate   and dateadd d  90  getdate

[sql] showing that a date is greater than current date

Examples related to sql

Examples related to sql-server

Examples related to tsql