ifnull doesn't work; add NZ timezone