• convert(varchar(30),@variable,120)

    just replace @variable with the column or value you want to format