URL_DEFAULT_PORT

Syntax

URL_DEFAULT_PORT(<URL string>)

Description

Gets the default port number of the protocol associated with this URL.

Examples

Column1URL_DEFAULT_PORT returns

http://www.datameer.com

80

ftp://ftp.datameer.com

21

gopher://gopher.datameer.com

70

https://www.datameer.com

443

file:///file.txt

-1