Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

Select DATENAME(hour, 2002-09-30 11

2>  select DATENAME(hour, '2002-09-30 11:35:00') 3> GO ------------------------------ 11 (1 rows affected) 1>