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

[eclipsed4utoo]

here is a good list for you...

http://anubhavg.wordpress.com/2009/0...l-server-2005/

the closest one for you is..

SELECT convert(varchar, getdate(), 105)

so your query would now be...

SELECT 
      Users.UserName
      , CONVERT(varchar, Attendence.TimeIn, 105) As 'TimeIn'
      , CONVERT(varchar, Attendence.TimeOut, 105) As 'TimeOut'
FROM 
      Users
          INNER JOIN Attendence
               ON Users.UserID = Attendence.UserID

This is assuming the fields are DateTime fields in the database. If not, you will need to convert them to DateTime, then convert them back to varchar.