How to use ,convert(datetime) in sql server 2005 in query

This function we can use when we need to convert or change the Date time format.
InSql query how can we use it is shown as below.
convert(varchar(10),convert(datetime,admission_date),103) as  ,admission_date
                                                                field name          format

Share This