I have a problem regarding in sqlserver date format.
my requirement is:-
i want to retrive date from table in '2nd Nov 2012
', '4th Dec 2012
'.... like this.
i.e select dtmadmission from tblstudent where intstudentId=8
o/p should be 24th Dec 2011
Please help me. it's very urgent.
Any help will be very much helpful.