Jeff Moden (7/10/2008)
I, too, can't wait until the split of Date and Time... leaves much opportunity to easily get to 15,000 posts in a hurry explaining to people how to fix what they have unwittingly done by using the split. 😉
I can see times when only a date is needed, or only a time, however I foresee lots of people having a data and a time stored in different columns in 1 table when they should be stored in a datetime.
Is gonna be fun doing a between when the date and the time are separate. :hehe:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability