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 11:53 am
#760781
Just cast fromdate (in the table) as a datetime like:
select fromdate from emp where cast(fromdate as datetime)>'2/16/2007'
as long as you are sure they are all valid datetimes otherwise the conversion will fail.