SQL date question

I have a question. I have a SQL Ser开发者_JS百科ver 2008 table with a field column. I have for example the Following dates:

1/1/2001
5/5/2004
8/5/2009
10/7/2011
5/5/2012
1/13/2014

Id like to be able to show all dates >= the current date (7/29/2011) as well as largest table date that is < current date. In this example, the result would be all dates >= 8/5/2009.

Can someone help guide me please??

select max(date) [date] from table where date < getdate()
union 
select date from table where date >= getdate()

If I understand correctly, you want to include the date prior to the current date. GETDATE() will get the current date (with time). If you're alright with that, then this should work. Otherwise, you may have to parse out just the date from GETDATE()

SELECT TheDate
FROM DateTable
WHERE TheDate >= (SELECT MAX(TheDate) FROM DateTable WHERE TheDate < GETDATE())

This gets all dates greater than or equal to the most recent date before the current date.

I am not entirely sure I understand, but this looks like a BETWEEN the relevant dates. Or is there something more I am missing?

Assuming your table is called DateTable and your field is called TheDate, do it like this:

SELECT TheDate
FROM DateTable
WHERE TheDate >= DATEADD(d, -2, GETDATE())

Good luck!

It depends on the SQL server you're using. In postgres, for example, you need something like

SELECT fields FROM table WHERE date_field >= CURRENT_DATE - 1

But other SQL servers have different ways to specify "yesterday"

SELECT d1.*
FROM dates d1
  LEFT JOIN dates d2 ON d1.Date < d2.Date AND d2.Date < GETDATE()
WHERE d2.Date IS NULL

Explanation:

Select every date for which there does not exist a date that is both earlier than today and later than the one being inspected.

Lots of guessing here based on loose narrative and unknown data types.

DECLARE @t TABLE(d DATE);

INSERT @t SELECT '20010101'
UNION ALL SELECT '20040505'
UNION ALL SELECT '20090805'
UNION ALL SELECT '20111007'
UNION ALL SELECT '20120505'
UNION ALL SELECT '20140113';

DECLARE @now DATE = SYSDATETIME();

WITH t AS
(
    SELECT d, rn = ROW_NUMBER() OVER (ORDER BY d)
    FROM @t
)
SELECT t.d
    FROM t LEFT OUTER JOIN t AS x
    ON t.rn = x.rn - 1
    WHERE COALESCE(x.d, @now) >= @now
    ORDER BY t.d;