Hello any one...

can anyone direct me how to create a dateformat in SQL..

mm-dd-yy hh:mm:ss: am or pm
example:
03-05-2011 03:56:25 pm