CODEWITHSUNDEEP
snowflake-cloud-data-platformbetween
Pasarome
Pasarome

Reputation: 1

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

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

Upvotes: 0

Views: 38

Answers (0)

Related Questions