> What on earth are you trying?
>
> select
> cast((cast('now' as TimeStamp) - dtm_stamp) as integer) as NumDays
> from tbl_event
> where .....
>

Oh gosh, how embarassing...
There's absolutely no way I'm showing you which tree I was barking up...

Thanks guys!

N.