Date formatting

Hi,
How do I get rid of the seconds in a date:
10/13/2004 8:27:00 PM
should read as
10/13/2004 8:27 PM
Thanks in advance
ChristianHi
Look at CAST and COVERT in BOL
Regards
Mike
"Christian Perthen" wrote:

> Hi,
> How do I get rid of the seconds in a date:
> 10/13/2004 8:27:00 PM
> should read as
> 10/13/2004 8:27 PM
> Thanks in advance
> Christian
>
>