there's not a specific predefined format for the string you are looking for;
two of the formats are pretty close, so by combining them you can get exactly what you want:
declare @date datetime
set @date=getdate()
SELECT CONVERT(VARCHAR,@date,111) + ' ' + LEFT(CONVERT(VARCHAR,@date,114),5)
--results:
2009/08/20 11:09
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!