Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Add few commonly used OOTB functions

Avatar

Level 3

17-10-2019

A lot of time we see that there are lack on the OOTB functions, for these we can obviously use SQL formula but an OOTB function will be always good.

1. Take hour, minute and second part from a datetime by using a single function.

2. Provide "Regular Expression" function to find a pattern of string.

3. In the Operator section of query, there is no "Ends with" option, we may use "Contains" but that will not always return the desired result.

2 Comments