for iOS

"MINAMO" DB function entered in the original product has been used internally by SQLite application functions and commands that can be converted to run on "SQL conversion" feature. But all the functions / can not convert command.

Currently available MINAMO conversion functions, and is shown below.

Name of the function

Oracle

SQLServer

Remarks

ADD_MONTHS

○

-

Only if the argument is SYSDATE

ASCII

○

○

CONCAT

○

-

COUNT_BIG

-

○

Convert COUNT

DATALENGTH

-

○

Convert LENGTH

GETDATE

-

○

INITCAP

○

-

Only convert the first letter

ISNULL

-

○

ISNUMERIC

-

○

LEN

-

○

LENGTHB

○

-

Convert LENGTH

LPAD

○

-

NVL

○

-

NVL2

○

-

RAND

-

○

RPAD

○

-

SIGN

○

○

SUBSTRB

○

-

Convert SUBSTR

SQL commands can be converted is as follows.

Oracle

SQLServer

CURRENT_DATE

○

-

CURRENT_TIMESTAMP

○

○

DELETE(FROMなし)

○

-

DUAL

○

-

SYSDATE

○

-

SYSTIMESTAMP

○

-

TO_CHAR

○

-

Argument SYSDATE, SYSTIMESTAMP only

Name of the function

Remarks

Home

Products

Support

About

MINAMO -Conversion Table for SQL