Pam Brisjar (1/9/2012)
I'm using one of Michael's versions and I'm getting NULL values when there is a date and the time is 0....
That is something I fixed in the version that I posted today.
Or you could fix the version you are using by replacing this:
dateadd(hh,nullif(@Time,0)/10000,0)))
with this:
dateadd(hh,@Time/10000,0)))