parse_ether
Scalar function
Shorthand for parse_units(value, 18). Converts ETH/WETH amounts to wei.
Overloads
parse_ether(VARCHAR)
Parse ETH amount string to wei (UINT256).
Parameters
| Name | Type |
|---|---|
| eth | VARCHAR |
Returns
| Name | Type |
|---|---|
| wei | UINT256 |
1
SELECT parse_ether('1.5'); -- 1500000000000000000
Notebook ready in readonly mode.
parse_ether(DOUBLE)
Parse ETH amount (double) to wei (UINT256).
Parameters
| Name | Type |
|---|---|
| eth | DOUBLE |
Returns
| Name | Type |
|---|---|
| wei | UINT256 |
1
SELECT parse_ether(0.5); -- 500000000000000000
Notebook ready in readonly mode.
parse_ether(FLOAT)
Parse ETH amount (integer) to wei (UINT256).
Parameters
| Name | Type |
|---|---|
| eth | FLOAT |
Returns
| Name | Type |
|---|---|
| wei | UINT256 |
1
SELECT parse_ether(1); -- 1000000000000000000
Notebook ready in readonly mode.
parse_ether(TINYINT)
Parameters
| Name | Type |
|---|---|
| arg1 | TINYINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(SMALLINT)
Parameters
| Name | Type |
|---|---|
| arg1 | SMALLINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(INTEGER)
Parameters
| Name | Type |
|---|---|
| arg1 | INTEGER |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(BIGINT)
Parameters
| Name | Type |
|---|---|
| arg1 | BIGINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(HUGEINT)
Parameters
| Name | Type |
|---|---|
| arg1 | HUGEINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(UTINYINT)
Parameters
| Name | Type |
|---|---|
| arg1 | UTINYINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(USMALLINT)
Parameters
| Name | Type |
|---|---|
| arg1 | USMALLINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(UINTEGER)
Parameters
| Name | Type |
|---|---|
| arg1 | UINTEGER |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(UBIGINT)
Parameters
| Name | Type |
|---|---|
| arg1 | UBIGINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |
parse_ether(UHUGEINT)
Parameters
| Name | Type |
|---|---|
| arg1 | UHUGEINT |
Returns
| Name | Type |
|---|---|
| result | UINT256 |