deepa ashwi

deepa ashwi

  • NA
  • 109
  • 602.3k

cast convert problem i want the format to be in dd/MM/yyyy

Aug 14 2013 12:24 AM
i am using right now

convert(char(29),datetime,109)it is of format Aug 13 2013 04:10:02:000 PM

but i want in dd/MM/yyyy 04:10:02 PM format i.e:13/08/2013 04:10:02PM

Answers (3)