How to get only hour from getdate() function in sql server?

Validating the user

Updated:  08/27/2007 08:08 AM
Author:  Shiju Mathews

Status:    Resolved.

Use datepart function.