Details
-
New Feature
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
This page from Markus Winand shows that numeric literals with undercore are SQL standard and partially work in some DBMSs:
https://modern-sql.com/caniuse/T662
Some people (including me) write 1 * 1000 * 1000 to make big values readable, but I can't say it's elegant. Underscores seem reasonably easy to implement, so please consider them.
I don't see it in SQL:2016, there is no T662 and the syntax for numbers is
<unsigned integer> ::=
<digit>...
<digit> ::=
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9