i write a query using pivot in that i want to format the date how can i do

See more:

C#

my query as follows;



select * FROM Tb_SCh_TIme_Table P PIVOT
(MAX(Faculty_Code) FOR Session IN ([1],[2],[3] ,[4])) AS PVT order by course.


when i run output as follows in sql;

Date course session1 session2 session3 session4

2013-01-15 00:00:00.000 Aff CK Vb RC SJ

i want the date format as follows in sql ouput;

Date course session1 session2 session3 session4

15-jan-2013 Aff CK Vb RC SJ

how can i do.what modification is needed in my above query,how can i do.