SQL 2008: Add sysdate()
With the new date/time data types in Katmai, a lot of people will try:
SELECT * FROM datecol = SYSDATETIME()
but since datecol will be autoconverted to datetime2(7), and there will be
no rows returned.
Yes, convert(date, sysdatetime()) is the simple workaround, but I expect
this to be an extremely common operation, why a sysdate() that returns
date is more than warranted.
It would be logical to add a systime() to make the collection complete, but this
is not equally compelling.