Is there any Snowflake SQL function which can I modify the limit type in Between clause?

33 views Asked by At

I'm looking for a function which can modify the limit type in between clause. eg: Date Between A and B includes A and B dates. But If the option I'm looking for is for include A and exclude B or viceversa. There is any function available to use instead of use

Date >=A and Date<B 

? The problem is to change the > instead of >= (the same for <) with the clause BETWEEN

I tried to look for in the community but I didn't find this specific case. SF doc neither have clearly this question solved

0

There are 0 answers