I've searched Stack Overflow but I can not find it.
In SQL Sever 2008 I have a table called "tbltemp" with a field called "day", this field is DateTime type.
When I consult direct dates on this field, it shows the following: Select day from tbltep
2017-03-20 00:00:00.000 2017-03-21 00:00:00.000 2017-03-22 00:00:00.000 2017-03-23 00:00:00.000
I would like to transform the query so that I can throw it in the following way:
Lun 20-03-2017 Mar 21-03-2017 Mie 22-03-2017 Jue 23-03-2017
(The query that I have is much larger than that but I do indeed need to transform the datetime data)