SQL Functions

Previous Next

This help topic shows how SQL functions are supported on different platforms. It also shows which functions are convertible between platforms.

 

collapseMore about this help topic

 

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

 

 

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

ABS

ABS

ABS

ABS

ABS

ABS

ACOS

ACOS

ACOS

ACOS

ACOS

ACOS

ADD_DAYS

ADD_DAYS

ADD_DAYS

ADD_DAYS

ADD_DAYS

ADD_DAYS

ADD_MONTHS

-

ADD_MONTHS

-

-

ADD_MONTHS

ADD_YEARS

-

-

-

-

ADD_YEARS

ASCII

ASCII

ASCII

ASCII

ASCII

ASCII

ASIN

ASIN

ASIN

ASIN

ASIN

ASIN

ATAN

ATAN

ATAN

ATAN

ATAN

ATAN

ATAN2

ATAN2

ATAN2

ATAN2

ATAN2

ATAN2

CASE

DECODE

DECODE

CASE

CASE

CASE

CAST

CAST

CAST

CAST

CAST

CAST

 

CHAR_TO_DATE

TO_DATE

CONVERT(datetime)

CAST

TO_DATE

CEIL

CEIL

CEIL

CEILING

CEILING

CEIL

 

CEILING

CEIL

CEILING

CEILING

CEILING

CEILING

CEIL

CEIL

CEILING

CEILING

CEIL

 

CEILING

CEIL

CEILING

CEILING

CEILING

CHAR

CHAR

CHAR

CHAR

CHAR

CHAR

CHARINDEX

CHARINDEX

INSTR

CHARINDEX

LOCATE

INSTR

 

INSTR

INSTR

CHARINDEX

LOCATE

INSTR

CHARTOROWID

-

CHARTOROWID

-

-

-

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

CHAR_TO_DATE

CHAR_TO_DATE

TO_DATE

CONVERT(datetime)

CAST

TO_DATE

CHR

-

CHR

-

-

CHR

COALESCE

IFNULL

NVL

ISNULL

ISNULL

COALESCE

 

NVL

NVL

ISNULL

ISNULL

COALESCE

COL_LENGTH

-

-

COL_LENGTH

-

-

COL_NAME

-

-

COL_NAME

-

-

CONCAT

CONCAT or || or +

CONCAT or || or +

CONCAT or || or +

CONCAT or || or +

CONCAT or || or +

CONVERT( datetime )

DATE_TO_CHAR

TO_CHAR( datetime )

CONVERT( datetime )

DATE_TO_CHAR

TO_CHARDATE

 

TO_INTEGER

TO_NUMBER

CONVERT( datetime )

TO_NUMBER

TO_NUMBER

CONVERT( integer )

-

TO_NUMBER

CONVERT( integer )

CONVERT

TO_NUMBER

CONVERT( ntext )

-

TO_NCLOB

CONVERT( ntext )

-

TO_NCLOB

CONVERT( number )

NUMBERTOCHAR

TO_CHAR( number )

CONVERT( number )

NUMBERTOCHAR

NUMBERTOCHAR

CONVERT( text )

CHAR_TO_DATE

TO_DATE

CONVERT( text )

CAST

TO_DATE

 

TO_CLOB

TO_CLOB

CONVERT( text )

TO_CLOB

TO_CLOB

COS

COS

COS

COS

COS

-

COSH

-

COSH

-

-

COSH

COT

COT

COT

COT

COT

COT

CURDATE

-

-

-

CURDATE

-

CURRENT_DATE

CURRENT_DATE

SYSDATE

GETDATE

NOW

SYSDATE

CURRENT_TIMESTAMP

-

-

-

CURTIME

CURRENT_TIMESTAMP

CURTIME

-

-

-

CURTIME

CURRENT_TIMESTAMP

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

DATABASE

-

-

-

DATABASE

-

DATALENGTH

-

-

DATALENGTH

-

-

DATEDIFF

DATEDIFF_IN_DAYS

DATEDIFF_IN_DAYS

DATEDIFF

DATEDIFF_IN_DAYS

DATEDIFF_IN_DAYS

DATEDIFF_IN_DAYS

DATEDIFF_IN_DAYS

DATEDIFF_IN_DAYS

DATEDIFF

DATEDIFF_IN_DAYS

DATEDIFF_IN_DAYS

DATEADD

-

-

DATEADD

-

DATEADD

DATENAME

-

-

DATENAME

-

-

DATEPART

-

-

DATEPART

-

-

DATE_TO_CHAR

DATE_TO_CHAR

TO_CHAR( datetime )

CONVERT( datetime )

DATE_TO_CHAR

TO_CHARDATE

DB_ID

-

-

DB_ID

-

-

DB_NAME

-

-

DB_NAME

-

-

DAYNAME

-

-

-

DAYNAME

-

DAYOFMONTH

-

-

-

DAYOFMONTH

-

DAYOFWEEK

-

-

-

DAYOFWEEK

-

DAYOFYEAR

-

-

-

DAYOFYEAR

-

DECODE

DECODE

DECODE

CASE

CASE

CASE

DEGREES

DEGREES

DEGREES

DEGREES

DEGREES

DEGREES

DIFFERENCE

-

-

DIFFERENCE

DIFFERENCE

-

DUMP

-

DUMP

-

-

-

ELAPSEDQUERY
TRANSACTIONTIME

ELAPSEDQUERY
TRANSACTIONTIME

ELAPSEDQUERY
TRANSACTIONTIME

ELAPSEDQUERY
TRANSACTIONTIME

ELAPSEDQUERY
TRANSACTIONTIME

ELAPSEDQUERY
TRANSACTIONTIME

ELAPSED
TRANSACTIONTIME

ELAPSED
TRANSACTIONTIME

ELAPSED
TRANSACTIONTIME

ELAPSED
TRANSACTIONTIME

ELAPSED
TRANSACTIONTIME

ELAPSED
TRANSACTIONTIME

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

EXP

EXP

EXP

EXP

EXP

EXP

FLOOR

FLOOR

FLOOR

FLOOR

FLOOR

FLOOR

GETDATE

CURRENT_DATE

SYSDATE

GETDATE

NOW

SYSDATE

GREATEST

-

GREATEST

-

-

-

HEXTORAW

-

HEXTORAW

-

-

-

HEXTOROWID

-

HEXTOROWID

-

-

-

HOST_ID

-

-

HOST_ID

-

-

HOST_NAME

-

-

HOST_NAME

-

-

HOUR

-

-

-

HOUR

-

IFNULL

IFNULL

NVL

ISNULL

ISNULL

COALESCE

 

NVL

NVL

ISNULL

ISNULL

COALESCE

INDEX_COL

-

-

INDEX_COL

-

-

INITCAP

-

INITCAP

-

-

INITCAP

INSERT

-

-

-

INSERT

-

INSTR

CHARINDEX

INSTR

CHARINDEX

LOCATE

INSTR

 

INSTR

INSTR

CHARINDEX

LOCATE

INSTR

INSTRB

-

INSTRB

-

-

INSTRB

ISINTEGER

ISINTEGER

ISINTEGER

ISINTEGER

ISINTEGER

ISINTEGER

ISNULL

IFNULL

NVL

ISNULL

ISNULL

COALESCE

 

NVL

NVL

ISNULL

ISNULL

COALESCE

ISNUMERIC

ISNUMERIC

ISNUMERIC

ISNUMERIC

ISNUMERIC

ISNUMERIC

LAST_DAY

-

LAST_DAY

-

-

LAST_DAY

LCASE

LOWER

LOWER

LOWER

LCASE

LOWER

LEAST

-

LEAST

-

-

-

LEFT

-

-

LEFT

LEFT

-

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

LEN

LENGTH

LENGTH

LEN

LENGTH

LENGTH

LENGTH

LENGTH

LENGTH

LEN

LENGTH

LENGTH

LENGTHB

-

LENGTHB

-

-

LENGTHB

LN

LOG

LN

LOG

LOG

LN

LOCATE

LOCATE

CHARINDEX

INSTR

CHARINDEX

LOCATE

 

INSTR

INSTR

INSTR

CHARINDEX

LOCATE

LOG

LOG

LN

LOG

LOG

LN

LOG10

LOG10

LOG10

LOG10

LOG10

LOG10

LOWER

LOWER

LOWER

LOWER

LCASE

LOWER

LPAD

-

LPAD

-

-

LPAD

LTRIM

LTRIM

LTRIM

LTRIM

LTRIM

LTRIM

MINUTE

-

-

-

MINUTE

-

MOD

MOD

MOD

MOD

MOD

MOD

MONTH

-

-

-

MONTH

MONTH

MONTHNAME

-

-

-

MONTHNAME

-

MONTHS_BETWEEN

-

MONTHS_BETWEEN

-

-

MONTHS_BETWEEN

NEW_TIME

-

NEW_TIME

-

-

NEW_TIME

NEXT_DAY

-

NEXT_DAY

-

-

NEXT_DAY

NLSSORT

-

NLSSORT

-

-

-

NLS_INITCAP

-

NLS_INITCAP

-

-

-

NLS_LOWER

-

NLS_LOWER

-

-

NLS_LOWER

NLS_UPPER

-

NLS_UPPER

-

-

NLS_UPPER

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

NOW

CURRENT_DATE

SYSDATE

GETDATE

NOW

SYSDATE

NULLVAL_CHAR

-

-

-

NULLVAL_CHAR

-

NULLVAL_INT

-

-

-

NULLVAL_INT

-

NUMBERTOCHAR

NUMBERTOCHAR

TO_CHAR( number )

CONVERT( number )

NUMBERTOCHAR

NUMBERTOCHAR

NVL

IFNULL

NVL

ISNULL

ISNULL

COALESCE

 

NVL

NVL

ISNULL

ISNULL

COALESCE

OBJECT_ID

-

-

OBJECT_ID

-

-

OBJECT_NAME

-

-

OBJECT_NAME

-

-

OLD

OLD

OLD

OLD

OLD

OLD

PATINDEX

-

-

PATINDEX

-

-

PI

PI

PI

PI

PI

PI

POWER

POWER

POWER

POWER

POWER

POWER

QUARTER

-

-

-

QUARTER

-

RADIANS

RADIANS

RADIANS

RADIANS

RADIANS

RADIANS

RAND

RAND

RAND

RAND

RAND

RAND

RAWTOHEX

-

RAWTOHEX

-

-

RAWTOHEX

RDBMSTYPE

RDBMSTYPE

RDBMSTYPE

RDBMSTYPE

RDBMSTYPE

RDBMSTYPE

RECORDS

RECORDS

RECORDS

RECORDS

RECORDS

RECORDS

REGEXP_INSTR

-

REGEXP_INSTR

-

-

REGEXP_INSTR

REGEXP_REPLACE

-

REGEXP_REPLACE

-

-

REGEXP_REPLACE

REGEXP_SUBSTR

-

REGEXP_SUBSTR

-

-

REGEXP_SUBSTR

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

REPEAT

-

-

-

REPEAT

-

REPLACE

REPLACE

REPLACE

REPLACE

REPLACE

REPLACE

REPLICATE

-

-

REPLICATE

-

-

REVERSE

-

-

REVERSE

-

-

RIGHT

-

-

RIGHT

RIGHT

-

ROUND

ROUND

ROUND

ROUND

ROUND

ROUND

 

TRUNC

TRUNC

ROUND

TRUNCATE

TRUNC

ROWIDTOCHAR

-

ROWIDTOCHAR

-

-

ROWIDTOCHAR

ROWNUM

ROWNUM

ROWNUM

ROWNUM

-

ROWNUM

RPAD

-

RPAD

-

-

RPAD

RTRIM

RTRIM

RTRIM

RTRIM

RTRIM

RTRIM

SECOND

-

-

-

SECOND

-

SESSION_ID

SESSION_ID

SESSION_ID

SESSION_ID

SESSION_ID

SESSION_ID

SIGN

SIGN

SIGN

SIGN

SIGN

SIGN

SIN

SIN

SIN

SIN

SIN

SIN

SINH

-

-

-

-

SINH

SOUNDEX

-

SOUNDEX

SOUNDEX

SOUNDEX

-

SPACE

-

-

SPACE

SPACE

-

SQRT

SQRT

SQRT

SQRT

SQRT

SQRT

STR

-

-

STR

-

-

STUFF

-

-

STUFF

-

-

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

SUBSTR

SUBSTR

SUBSTR

SUBSTRING

SUBSTRING

SUBSTR

 

SUBSTRING

SUBSTR

SUBSTRING

SUBSTRING

SUBSTR

SUBSTRB

-

SUBSTRB

-

-

-

SUBSTRING

SUBSTR

SUBSTR

SUBSTRING

SUBSTRING

SUBSTR

 

SUBSTRING

SUBSTR

SUBSTRING

SUBSTRING

SUBSTR

SUSER_ID

-

-

SUSER_ID

-

-

SUSER_NAME

-

-

SUSER_NAME

-

-

TAN

TAN

TAN

TAN

TAN

TAN

TANH

-

TANH

-

-

TANH

TEXTPTR

-

-

TEXTPTR

-

-

TEXTVALID

-

-

TEXTVALID

-

-

TIMESTAMPADD

-

-

TIMESTAMPADD

-

-

TIMESTAMPDIFF

-

-

TIMESTAMPDIFF

-

-

TIMESTAMP_TO_DATE

TIMESTAMP_TO_DATE

TIMESTAMP_TO_DATE

TIMESTAMP_TO_DATE

TIMESTAMP_TO_DATE

-

TOP

RECORDS

RECORDS

TOP

RECORDS

RECORDS

TO_CHAR( datetime )

DATE_TO_CHAR

TO_CHAR( datetime )

CONVERT( datetime )

DATE_TO_CHAR

TO_CHARDATE

TO_CHAR( number )

NUMBERTOCHAR

TO_CHAR( number )

CONVERT( number )

NUMBERTOCHAR

NUMBERTOCHAR

TO_CHARDATE

DATE_TO_CHAR

TO_CHAR( datetime )

CONVERT( datetime )

DATE_TO_CHAR

TO_CHARDATE

TO_CLOB

TO_CLOB

TO_CLOB

CONVERT (text)

TO_CLOB

TO_CLOB

TO_DATE

CHAR_TO_DATE

TO_DATE

CONVERT( text )

CAST

TO_DATE

TO_INTEGER

TO_INTEGER

TO_NUMBER

CONVERT( datetime )

TO_NUMBER

TO_NUMBER

TO_MULTI_BYTE

-

TO_MULTI_BYTE

-

-

TO_MULTI_BYTE

TO_NCHAR

TO_NCHAR

TO_NCHAR

TO_NCHAR

TO_NCHAR

TO_NCHAR

TO_NCLOB

-

TO_NCLOB

CONVERT (ntext)

-

TO_NCLOB

TO_NUMBER

TO_INTEGER

TO_NUMBER

CONVERT( datetime )

TO_NUMBER

TO_NUMBER

TO_NVARCHARMAX

-

-

TO_NVARCHARMAX

-

-

Name

USoft

Oracle

MS SQL Server

ODBC

JDBC, Derby

TRANSACTION_DATE

TRANSACTION_DATE

TRANSACTION_DATE

TRANSACTION_DATE

TRANSACTION_DATE

TRANSACTION_DATE

TRANSLATE

-

TRANSLATE

TRANSLATE

-

-

TRUNC

TRUNC

TRUNC

ROUND

TRUNCATE

TRUNC

TRUNCATE

TRUNC

TRUNC

ROUND

TRUNCATE

TRUNC

UCASE

UPPER

UPPER

UPPER

UCASE

UPPER

UID

-

UID

USER_ID

-

-

UPPER

UPPER

UPPER

UPPER

UCASE

UPPER

USER

USER

USER

USER

USER

USER

USERENV

-

USERENV

-

-

USERENV

USERGROUP

USERGROUP

USERGROUP

USERGROUP

USERGROUP

USERGROUP

USER_ID

-

UID

USER_ID

-

-

USER_NAME

-

-

USER_NAME

-

-

VSIZE

-

VSIZE

-

-

VSIZE

WEEK

-

-

-

WEEK

-

YEAR

YEAR

YEAR

YEAR

YEAR

YEAR

 

 

See also

RDBMS Functions

Pseudo-columns