js-sql-parser icon indicating copy to clipboard operation
js-sql-parser copied to clipboard

LEFT(string, charcters length), RIGHT(string, characters length) not getting exact result

Open T-Deepthy opened this issue 4 years ago • 1 comments

LEFT(string, charcters length), RIGHT(string, characters length) not getting exact result as we expect instead throw error

T-Deepthy avatar Jul 05 '21 07:07 T-Deepthy

hi @T-Deepthy . currently , you can use left, right function like

select `left`(a, 2) from dual;

This is my test:

image

Syntax with out ` will be supported in the future.

albin3 avatar Jul 05 '21 15:07 albin3