From TeraData SQL assist, you get 7 as result from the query.

In TSQL, you may able to do the following
declare @actvt_dt date = '2015-08-22'
SELECT CASE WHEN...