I have been asked this question “How to get hour, minute and second from date time?” from a developer last week.
Let me explain it with a simple example.
Declare @DateTime As Datetime Set @DateTime = Getdate() Select @DateTime as [DateTime] Select DatePart(Hour,@Datetime) as [Hour] Select DatePart(Minute,@Datetime) as [Minutes] Select DatePart(Second,@Datetime) as [Seconds] --Result DateTime ----------------------- 2012-09-25 18:12:45.420 (1 row(s) affected) Hour ----------- 18 (1 row(s) affected) Minute ----------- 12 (1 row(s) affected) Second ----------- 45 (1 row(s) affected)
SQL Server Portal 
Leave a Reply