Let's $\Phi$ represent the standard normal CDF, and q the required var quantile (e.g., 95%) so your $z=\Phi^{-1}\left(q\right)$.
Now assume the return x is normally distributed with annualised mean $\mu$ and annualised standard deviation $\sigma$. By the way you can annualise your daily volatility by scaling it by $\sqrt{258}$ because we are in simple normal distribution world, and you are assuming 258 days in a year. So we can write the quantile as follows:
$\Phi \left(\frac{x_q-\mu t}{\sigma \sqrt{t}}\right)=q$
We can rearrange,
$x_q=\mu t+{\sigma \sqrt{t}}\Phi^{-1} \left(q\right)$
So it is similar to your formula but with a drift. But please note t here is measured in years, and $\mu$ and $\sigma$ are annualised.
For smaller holding periods such as 1 day, you can ignore the mean/drift, but this becomes significant for longer holding periods. So as you increase the holding period, the process drift (upward or downward depending on the sign) and the variance grows. If you assume zero drift, the VaR will grow with the holding period. Which is intuitive because holding a stock, which is risky asset, for 10 years can make you a lot richer (or poorer!). But if you think the variance is growing too fast than could be considered realistic, then you can consider alternative specifications for the return process. In the interest rate world, an alternative mean reverting specification is more common, so the variance grows with horizon but at a deceasing rate. The simplest examples is the Vasicek model and is based on the Ornstein Uhlenback process, but I can see your question relates to simple settings so won’t go there.
There is also a chance you might be referring to the holding period as the length of the observation windows that you used to estimate the daily volatility. If that's the case, then just changing the observation window shall not by itself increase the VaR because we are annualising the volatility (the annual variance will be 258 times the daily variance under the above assumptions, irrespective of whether you estimate it using 258 days period or 2580 days period).