Creating a Computed Column as a DATE Data Type

Today our lesson is based on a reader question - how do you get a computed column to be of type DATE instead of DATETIME? We'll show you the original implementation and then a solution that uses the CONVERT function. Short and sweet, you might find this idea useful one day.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Mike on 12/6/2010

Nice easy start to my week!

Surya Prakash on 12/6/2010

Good

Will Casey on 12/6/2010

good to know

Rubens on 12/6/2010

Really good info, I find all of your videos very informative and nice and concise.

Jamshid Nouri on 12/6/2010

excellent

Alexander on 12/6/2010

very useful

Mat on 12/6/2010

i love your site.

Nilesh on 12/7/2010

good

Dan O'Keefe on 12/8/2010

Excellent since one of the most frustrating aspects of SQL is working with dates and times

Mohamed Irshad on 12/31/2010

very good

Doug McGlasson on 4/17/2011

doesn't explain why the final result is a 12/05 datetime but date is 12/6