Convert function for times 1

[TeriCoombes]

I have been looking for a conversion style number that will change my datetime field from 1/1/1900 03:00:00 to 03:00 (hh:mm). Everything I have seen so far are styles that will change my field to hh:mm:ss. What I am trying to ask is if there is a style code for just hh:mm? Any help would be appreciated.

 

[JayKusch]

Unless you put a SUBSTRING command around your CONVERT and Style option, there is no default Sytle that will just give you the Hours and Minutes alone. SO ... it "may" look something like ...

SELECT SUBSTRING(CONVERT(VarChar,GetDate(),114),1,5)

Of course, swap GetDate() w/ your date field. The above example will work in Query Analyzer though!

Thanks

J. Kusch

 

[TeriCoombes]

It worked. Thanks.