data type datetime ??

[quadri]

when executing a query in sql 2005
select getdate() what you get , suppose

2008-05-08 12:41:10.587

Is ther any query where i can get date only and the datatype should be in datatime.
Is there any datatype only " date " in sql 2005. I heard its in sql 2008 ?
My exact problem is
For example ,here startdate datatype is datetime.
select * from dbo.Emp where startdate between 2008-05-08 and 2008-05-08.
i am getting 0 rows here.
what is the best way to select this query.

hope i explained it clearly.


TIA

[quadri]

i found somthing related to it

http://www.sql-server-performance.com/articles/dev/datetime_2008_p 1.aspx

[code green]

This one method.

SELECT CONVERT(VARCHAR,GETDATE(),103)

You can also use different types from VARCHAR and different codes to change the format
This is a very good article

http://www.sqljunkies.ddj.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk