Date format problem

Hello all,
This has been bugging me for most of the day. The sql statement below works just fine. It displays the date in the correct format. But, i want to include the time as well.

SELECT id, CONVERT(varchar(10), request_id) + Space(1) + CONVERT(varchar(20), date, 101) AS REQUEST, seen FROM Notes WHERE seen = '0'

Any ideas?
Thanks in advance.

Richard M.

SELECT id, CONVERT(varchar(10), request_id) + Space(1) + CONVERT(varchar(20), date, 101) + Space(1) + CONVERT(varchar(20), date, 108) AS REQUEST, seen FROM Notes WHERE seen = '0'

|||Thanks. I can't believe it was that simple.

Richard M.