[dba-SQLServer] SQL Server date functions

Just for completeness, JC, here's a function to grab just the time part,
called (gasp) TimePart(). Where do I come up with these names?

<code>
CREATE FUNCTION [dbo].[TimePart]
  ( @fDate datetime )
RETURNS varchar(10)
AS
BEGIN
  RETURN ( CONVERT(varchar(7),right(@fDate,7),101) )
END
</code>

Arthur