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!
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!