Get earliest date from simple list

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

declare @dateList table(targetDate date);
insert into @dateList 
values ('2012-01-12'), ('2012-02-12'), ('2011-02-12')

select top 1 targetDate as 'earlistTargetDate' from @dateList;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results