You will have make use of combinations of CONVERT functions.
select cast(convert(varchar, getdate(),112) + ' ' + left(convert(varchar,
getdate(),108), 5) as datetime)
"Przemo" <p.dutkiewiczdeltatrans.pl> wrote in message
> I have chenged my datebase from Access to sql2000. I have
> problems with formatting of datetime values. I have used
> Format function in access.
> 1. In sql2000 I see that there is only function CONVERT with
> predefined format. And what if I would like to get from
> datetime value only time in format hh:mm ?
> 2. How to convert ...