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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-04 : 08:18:24
|
| trilok gubba writes "I want to get the hour value from the datetime datatype.The quey i got is display all instructors who have evening classes.I want to list all classes which are after 05:00 pm .so how can i ger the hour part from the datetime datatype.please help me regarding this." |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-04 : 08:22:30
|
| select * from yourtable where datepart(hour, yourdatetimecolumn) >= 17Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
regarding date time