Does anyone know how to take the Time piece out of a DateTime field? I tried datepart but then I have to put it back together and the other problem with that is that it doesn't give me hh:mm:ss format. I get h:m:s format.
I'm pretty sure I'm not confused about what my users what displayed. They want the time portion only of the datetime field. I looked up convert and datetime and don't see any way to just get the time. So I wrote a little UDF to pull it out.
That?! That code was "amazing"? I have some glass beads I'd be willing to trade for your property if you are interested. (I say this only because I know it will be several days before Pat has a chance to get back at me...)
If it's not practically useful, then it's practically useless.