The Snowflake documentation is pretty clear that this is set at the account level, so you cannot adjust it in a query.
You can generate dates using other methods. For instance:
select dateadd(day, row_number() over (order by null), '2030-05-26') ) as date from table (generator(rowcount => (10000)));
I don’t know what the right value of “10000” is for your purposes.
CLICK HERE to find out more related problems solutions.