How can i change date format

[touseef4pk]

hi dears,

I have this join query

string qry = "Select Users.UserName, Attendence.TimeIn, Attendence.TimeOut from Users Inner Join Attendence on Users.UserID = Attendence.UserID";

where TimeIn and TimeOut are date columns and their date format is dd/mm/yy.
Please tell me how can i change my date format in this join query when retrieving these records from database. I want to show this format like that dd-mm-yy. Pleae guide