parse_gwei
Scalar function
Shorthand for parse_units(value, 9). Converts gwei to wei.
Overloads
parse_gwei(VARCHAR)
Parse gwei amount string to wei (UINT256).
Parameters
| Name | Type |
|---|---|
| gwei | VARCHAR |
Returns
| Name | Type |
|---|---|
| wei | UINT256 |
1
SELECT parse_gwei('20'); -- 20000000000
Notebook ready in readonly mode.
parse_gwei(DOUBLE)
Parse gwei amount (double) to wei (UINT256).
Parameters
| Name | Type |
|---|---|
| gwei | DOUBLE |
Returns
| Name | Type |
|---|---|
| wei | UINT256 |
1
SELECT parse_gwei(1.5); -- 1500000000
Notebook ready in readonly mode.
parse_gwei(FLOAT)
Parse gwei amount (integer) to wei (UINT256).
Parameters
| Name | Type |
|---|---|
| gwei | FLOAT |
Returns
| Name | Type |
|---|---|
| wei | UINT256 |
1
SELECT parse_gwei(20); -- 20000000000
Notebook ready in readonly mode.
parse_gwei(TINYINT)
Parameters
| Name | Type |
|---|---|
| arg1 | TINYINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(SMALLINT)
Parameters
| Name | Type |
|---|---|
| arg1 | SMALLINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(INTEGER)
Parameters
| Name | Type |
|---|---|
| arg1 | INTEGER |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(BIGINT)
Parameters
| Name | Type |
|---|---|
| arg1 | BIGINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(HUGEINT)
Parameters
| Name | Type |
|---|---|
| arg1 | HUGEINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(UTINYINT)
Parameters
| Name | Type |
|---|---|
| arg1 | UTINYINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(USMALLINT)
Parameters
| Name | Type |
|---|---|
| arg1 | USMALLINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(UINTEGER)
Parameters
| Name | Type |
|---|---|
| arg1 | UINTEGER |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(UBIGINT)
Parameters
| Name | Type |
|---|---|
| arg1 | UBIGINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_gwei(UHUGEINT)
Parameters
| Name | Type |
|---|---|
| arg1 | UHUGEINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |