Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 Hour from a date

Author  Topic 

shajimanjeri
Posting Yak Master

179 Posts

Posted - 2006-10-28 : 04:54:39
How to get hour from a date

Msg_Time = 10/28/2006 12:20:00 AM

here how to get hour, minuts

see for month we are using month(Msg_Time),
for year we are using year(Msg_Time) same way how to fetch the hour and minutes

all are appreciate

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-28 : 04:59:28
use datepart(hour, datecol) or datepart(minute, datecol)

Please also post in appropriate forum. The Script Library is for posting working script



KH

Go to Top of Page
   

- Advertisement -