SQL Server/Date &Time conversion for vb.net

jpetter7

Member
Joined
Jul 20, 2004
Messages
16
Programming Experience
Beginner
Hello all! I am trying to pull the time- hour/minutes out of a sql server query. When I attempt this.. I keep getting errors

Select datepart(hh:mm, time1)
From Table1

I have put the hh and mm in "hh:mm", 'hh:mm', and all types of variatons, but it keeps giving me errors. Any help with this will be greatly appreciated. Thank you in advance!
 
Top Bottom