Blogger Jeff = new Blogger

Programming and stuff in Western PA

Finally, just DATES in SQL Server 2008

I’m just getting around to snooping around Sql Server 2008, and noticed that they have FINALLY added just a DATE datatype. What this means is that we can now just store a date, rather than a date and the time. No more will we have to write SELECT CONVERT(VARCHAR,GETDATE(),101)!!!!!

This now does the trick :

SELECT CAST(GETDATE() AS DATE)

December 18, 2008 Posted by | Technology | | Leave a comment