I have a field in a datetime format. When I do an insert into an existing table with a date field, I want the format to be 'MM/DD/YYYY'
I have the following statement:
convert(date,LastBilledDateTime,101) as LBDT.
When I look at the output the format is YYYY-MM-DD.
How can force it be MM-DD-YYYY? The LastBilledDateTime is stored as DateTime.