select datepart(hour,getdate()) as [hours] DatePart Function will retrieve part of the date. Syntax:DATEPART(part, datetime) Part—-Ms for MillisecondsYy for YearQq for Quarter of the YearMm for MonthDy for the Day of the YearDd for Day of the MonthWk for WeekDw for the Day of the WeekHh for HourMi for MinuteSs for Second You can replace part with the any […]