Home Forums SQL Server 7,2000 T-SQL DateTime Problem RE: DateTime Problem
Adrienne250
Right there with Babe
Points: 737
More actions
December 17, 2007 at 12:29 pm
#760790
I don't know if you want to use a temp table but this should work
select *
into #temp
from emp
where isDate(fromdate) = 1
select fromdate
from #temp
where cast(fromdate as datetime)>'2/16/2007'