>Hi All, > >I will create a datetime field. I'll save date and time to it. I need date and time and have filtering just date part. Should I create an index like; > >CONVERT(char(10),mydate,112) > >and use; >vfp: >xmydate=dtoc(date(),1) >sql server: >where convert(char(10),mydate,112)=?xmydate > >for performance > >or is just an index with mydate is enough for performance; > >vfp: >xmydate=date() >sql server: >where mydate=?xmydate
Metin,
In SQL Server you can not create an index using a function. Use a date range when looking for a date, e.g.
select * from myTable where DateField >=@Today and DateField < @Tomorrow