format computed column to remove time from datetime column

I need to format the datetime on a columnin SQL 2005 to remove the time from the column
mphillip85Asked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
drop it and then recreate it

alter table tablename
drop column yourcomputedcolumnname

alter table tablename
add yourcomputedcolumnname as convert(varchar(10), datecolumn, 101)  --you have to specify the length of the varchar field.
0
 
pzozulkaCommented:
CONVERT(VARCHAR,DateColumn,101)
0
 
mphillip85Author Commented:
this needs to work as a computed formula on the column in SQL 2005 Server table
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.