The second publicly available Community Technology Preview (CTP) for SQL Server 2008 is now available for download from the Microsoft connect site. Included in this CTP is something that many people have wanted for a long time and that is the inclusion of a separate date and a separate time data type, so no more casting the datetime datatype any longer.
For more details regarding the July CTP including the download details refer to here.
