Good question kapil.

I feel that this question contains it's answer in itself. Why i think so? Let me tell you.

In question, you told that you need the output like:- "Apr 9 2013 11:38AM".

This output comes when we convert any datetime in varchar (string format) with different format option. like:-

SELECT CONVERT(VARCHAR, GETDATE(),100), CONVERT(VARCHAR, GETDATE(),101), CONVERT(VARCHAR, GETDATE(),110)

This one point to correct answer. 🙂

One minor mistake i found that, You need output like "Apr 9 2013 11:38AM", But below all queries give today day. oops !!! 🙂

No problem.

Thanks of start my day with good question.

🙂